3 ways to get an accurate count of the number of records in a table? By Gaurav Agrawal | January 17, 2013 - 5:10 PM |June 29, 2021 Database Management SELECT * FROM tbl SELECT COUNT(*) FROM tbl SELECT rows FROM sysindexes WHERE id=OBJECT_ID(tbl) AND indid<2 Tagged SQL. Bookmark the permalink.