script to find the rowcounts of all the tables in a database
| SELECT o.name, i.[rows] FROM sysobjects o INNER JOIN sysindexes i ON o.id = i.id WHERE (o.type = 'u') AND (i.indid = 1) ORDER BY o.name |
No comments:
Post a Comment