MS SQL Server 테이블 건수 용량 확인 쿼리
--------------------------------------------------------------------------------- -- table 건수 select a.name ,a.id ,b.rows from sysobjects a left outer join sysindexes b on b.id = a.id where a.xtype = 'u' and b.indid < 2 order by b.rows desc -------------------------------------------------------------------------------- -- table 용량 select a.id, a.name ,str(sum(reserved) * 8192.0 / 1024.0, 15, 0)..
DataBase/SQL Server
2021. 1. 4. 16:03
