|
Posted by digispace on 01/11/06 21:26
There a stored procedure or query that will count all the records
in all my tables in a database.
One of these two -
exec sp_MSforeachtable N'SELECT "table" = ''?'', cnt = COUNT(*) FROM ?'
select object_name(id), rows from sysindexes where indid in (1, 0)
Is there a way to add columns to the second query? I would like to see
how many columns and their names as well.
Thanks.
Navigation:
[Reply to this message]
|