Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL: 'user_tables' table question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-13 : 01:51:26
frank writes "how do you get a listing of all table names plus the number of rows each contains, the num_rows column does not contain pertinent data, and I can seem to use count(*) to get the info I want.

Thank you Guru Dude
Frank 'If I was any less inteligent I would be in a group home' Vokoun"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-05-13 : 01:51:26
A variation on this script should work (http://www.sqlteam.com/item.asp?ItemID=282).
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-13 : 07:29:27
This should work too:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15531

Go to Top of Page
   

- Advertisement -