How do I count the number of Records in a Table?

×
If you need to count the number of records in a table, use the following query:

SELECT COUNT ( * ) AS RecordCounter
FROM TableName
 
Replace TableName with the name of your Table.
 
This will return one column named RecordCounter with the total number of records for the Table.