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
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
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.