• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Here is SQL script to List all tables names and row counts of the table

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

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

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

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