SELECT 'Addresses' AS TableName, COUNT(*) AS RowCount FROM Addresses
UNION
SELECT 'Customers' AS TableName, COUNT(*) AS RowCount FROM Customers
UNION
SELECT 'Departments' AS TableName, COUNT(*) AS RowCount FROM Departments
UNION
SELECT 'Employees' AS TableName, COUNT(*) AS RowCount FROM Employees
UNION
SELECT 'LineItems' AS TableName, COUNT(*) AS RowCount FROM LineItems
UNION
SELECT 'Products' AS TableName, COUNT(*) AS RowCount FROM Products
UNION
SELECT 'Ref_AddressTypeCode' AS TableName, COUNT(*) AS RowCount FROM Ref_AddressTypeCode
UNION
SELECT 'Ref_CountryCode' AS TableName, COUNT(*) AS RowCount FROM Ref_CountryCode
UNION
SELECT 'Ref_EmployeeStatusCode' AS TableName, COUNT(*) AS RowCount FROM Ref_EmployeeStatusCode
UNION
SELECT 'Ref_OrderStatusCode' AS TableName, COUNT(*) AS RowCount FROM Ref_OrderStatusCode
UNION
SELECT 'Sales' AS TableName, COUNT(*) AS RowCount FROM Sales
; |