IFOBJECT_ID('tempdb..#TB_TEMP_SPACE')ISNOTNULLDROPTABLE#TB_TEMP_SPACEGOCREATETABLE#TB_TEMP_SPACE(NAMEVARCHAR(500),ROWSINT,RESERVEDVARCHAR(50),DATAVARCHAR(50),IN...

 //查询数据库各表占用空间的情况droptable#tcreatetable#t(namevarchar(255),rowsbigint,reservedvarchar(20),datavarchar(20),index_sizevarchar(20),unusedvarchar(20))execsp_MS...

#倒序查询数据库【各表记录数】useinformation_schema;selecttable_name,table_rowsfromtableswhereTABLE_SCHEMA='数据库名'orderbytable_rowsdesc; ...