Nomber of records in each table

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Nomber of records in each table

Message

From

26/12/2008 16:10:52

26/12/2008 10:26:10

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Miscellaneous

Thread ID:

01369750

Message ID:

01369794

Views:

>Is there a SQL command I can use to get a list of all the tables along with the number of records in each table in a database?
>
>Thanks,
>Einar

select rowcnt,object_name(id) 
from sysindexes
where indid < 2 and object_name(id) not like 'sys%'

Cetin