Подсчет количества записей в каждой из таблиц базы данных MSSQL

Posted by on Thursday, June 10, 2010 Leave a comment (0) Go to comments 
select substring(o.name, 1, 30) Table_Name ,i.rows Number_of_Rows
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.xtype = 'u'
and i.indid < 2
order by o.name

делись@распространяй

Share to Google Plus
Tech