Posted in Binary
on May 2nd, 2008 | 0 comments
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...