iscomar001
3/12/2014 - 3:15 PM
Tables Size
Tables Size
SELECT t.name TableName, i.rows Records
FROM sysobjects t INNER JOIN sysindexes i
ON i.id = t.id
WHERE t.xtype = 'U'
and i.indid in (0,1)
and t.name <> 'sysdiagrams'
ORDER BY i.rows desc;Tables Size
SELECT t.name TableName, i.rows Records
FROM sysobjects t INNER JOIN sysindexes i
ON i.id = t.id
WHERE t.xtype = 'U'
and i.indid in (0,1)
and t.name <> 'sysdiagrams'
ORDER BY i.rows desc;