Find the Number of Records in a Table
Delphi is especially useful in developing data-based applications. You will find that you can develop desktop applications very quickly after your Delphi studies and research.
If you are using Table: With RecordCount, you can find the total number of records in the table with Count (*) if you are using Query. Do not use the Table component and the RecordCount command in SQL databases that you should be aware of. Because in this case all the data in the table will be uploaded to the client, unnecessary slowdown and network traffic will occur.
Query: SELECT COUNT (*) FROM TABLE_PAGE