VBcoders Guest



Don't have an account yet? Register
 


Forgot Password?



Here is SQL script to List all tables names and row counts of the table

by Ritik Dodhiwala (5 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Mon 3rd September 2007
Date Added: Mon 8th February 2021
Rating: (1 Votes)

Here is SQL script to List all tables names and row counts of the table

Rate Here is SQL script to List all tables names and row counts of the table



FROM         dbo.sysobjects so INNER JOIN
                      dbo.sysindexes si ON so.id = si.id
WHERE     (so.xtype = 'u') AND (si.indid < 2) AND (so.name <> 'dtproperties')
ORDER BY so.name

Download this snippet    Add to My Saved Code

Here is SQL script to List all tables names and row counts of the table Comments

No comments have been posted about Here is SQL script to List all tables names and row counts of the table. Why not be the first to post a comment about Here is SQL script to List all tables names and row counts of the table.

Post your comment

Subject:
Message:
0/1000 characters