mssql table 용량
-
MS-SQL 테이블 용량(크기) 확인 하는 방법프로그램/Mssql 2024. 1. 23. 11:54
SET NOCOUNT ON CREATE TABLE #TBLSize ( Tblname varchar(80), TblRows int, TblReserved varchar(80), TblData varchar(80), TblIndex_Size varchar(80), TblUnused varchar(80) ) DECLARE @DBname varchar(80) DECLARE @tablename varchar(80) SELECT @DBname = DB_NAME(DB_ID()) PRINT 'User Table size Report for (Server / Database): ' + @@ServerName + ' / ' + @DBName PRINT '' PRINT 'By Size Descending' DECLARE T..