Technical Article

All tablename and Record Count in a Database

,

Hello,

Here is a way that help in getting all the table name and rowcount with in a database
The use can give the database name and it will show the output for that database.

Output can be ordered by name or by number of rows.


To use it :

Copy the script and run paste in QA and run.

[tested on SQL 7/2000]


Raj-(Md.Sufian)
Thailand

SELECT 
    [TableName] = so.name, 
    [Table id]=so.id,
    [RowCount] = MAX(si.rows) 
 FROM 
sysobjects so, sysindexes si 
WHERE 
    so.xtype = 'U' 
    AND   si.id = OBJECT_ID(so.name) 
GROUP BY 
    so.name,so.id 
ORDER BY 
    2 DESC

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Join the discussion and add your comment

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Related content

SQLServerCentral Article

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.92 (12)

You rated this post out of 5. Change rating

2018-05-18 (first published: )

4,786 reads

Technical Article

Query to Display Trigger Status

Ever wanted to know whether your triggers are enabled or not? The ObjectProperty command allows you to select information about the status of objects in your database, returning 1 for True and 0 for False. The example below determines whether a single trigger is disabled. SELECT ObjectProperty(object_id('Trigger_Name'), 'ExecIsTriggerDisabled') There are a number of other useful […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2001-10-28

1,196 reads