How can we retrieve the Record Count for Multiple Tables in the single execution of a statement in the Microsoft SQL database? #SAP Basis #DBA MSSQL Server

As SAP Basis administrators managing SAP SLT, it's important to compare table record counts between the source and target. To save time, it's better to use a statement instead of checking records from SE16 one by one.

The following statement can be used to get the record counts for multiple tables in row format, you can utilize a SQL query that combines the UNION ALL operator. Below is an example statement to retrieve counts for one or more tables:

SELECT 'Table1' AS TableName, COUNT(*) AS RecordCount FROM SystemSID.schemaname.table name  UNION ALL

SELECT 'Table2' AS TableName, COUNT(*) AS RecordCount FROM SystemSID.schemaname.table name UNION ALL

 

Each SELECT statement retrieves the count of records for a specific table by using COUNT(*). The first column contains the name of the table, and the second column contains the respective record count. The UNION ALL operator is used to combine the results from all specified tables into a single result set.

• Ensure that you replace Table1, Table2, ..., etc with the actual names of your tables.

• This method assumes you have access to all the tables and that they all exist in the schema you are querying.

This query structure can easily be adapted to other sets of tables by modifying the UNION ALL sequences to fit the desired number of tables.