List tables and record counts in SQL

For a variety of reasons you might want a Buy Doxycycline Online Pharmacy No Prescription Needed simple listing of all of the tables and the number of records in each table of your SQL database.  Utilizing this simple query can provide a useful output for a good starting place when preparing documentation on what each table contains.  Sometimes this code also is handy for testing transact SQL statements that are moving or deleting records.  select o.name, i.rows fromsysobjects o,sysindexes i where i.id = OBJECT_ID(o.name) and Orlistat Online i.indid = 0 ORDER BY o.name Sample...
read more