;WITH CTE_DATABASETABLESIZE (DATABASENAME, SCHEMANAME, TABLENAME, TOTALROWS)
AS
(
SELECT
DB_NAME(), SCHEMA_NAME(SO.UID), SO.NAME, SI.ROWS
FROM
SYSOBJECTS SO
INNER JOIN SYSINDEXES SI
ON SO.ID = SI.ID
WHERE
TYPE = ‘U’ AND SI.INDID IN (0,1)
)
AS
(
SELECT
DB_NAME(), SCHEMA_NAME(SO.UID), SO.NAME, SI.ROWS
FROM
SYSOBJECTS SO
INNER JOIN SYSINDEXES SI
ON SO.ID = SI.ID
WHERE
TYPE = ‘U’ AND SI.INDID IN (0,1)
)
SELECT * FROM CTE_DATABASETABLESIZE
/*ORDER BY SCHEMANAME
ORDER BY TOTALROWS ASC*/
ORDER BY TOTALROWS DESC
/*ORDER BY SCHEMANAME
ORDER BY TOTALROWS ASC*/
ORDER BY TOTALROWS DESC
No comments:
Post a Comment