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.

[Back to original message]