/*
 * Row count for the pentaho sampledata database
 * Gaspard.Duquesnoy 
 * 09/18/2009 
 * http://osbi.nl
 * http://euclides.nl
 *
*/ 

USE sampledata;

SELECT 'CUSTOMERS' as table_name, count( * ) AS rows FROM CUSTOMERS
union 
SELECT 'CUSTOMER_W_TER' as table_name , count( * ) AS rows from CUSTOMER_W_TER
union 
select 'DEPARTMENT_MANAGERS' as table_name, count(*) as rows from DEPARTMENT_MANAGERS
union 
select 'DIM_TIME' as table_name, count(*) as rows from DIM_TIME
union 
select 'EMPLOYEES' as table_name, count(*) as rows from EMPLOYEES
union 
select 'OFFICES' as table_name, count(*) as rows from OFFICES
union 
select 'ORDERDETAILS' as table_name, count(*) as rows from ORDERDETAILS
union 
select 'ORDERFACT' as table_name, count(*) as rows from ORDERFACT
union 
select 'ORDERS' as table_name, count(*) as rows from ORDERS
union 
select 'PAYMENTS' as table_name, count(*) as rows from PAYMENTS
union 
select 'PRODUCTS' as table_name, count(*) as rows from PRODUCTS
union 
select 'QUADRANT_ACTUALS' as table_name, count(*) as rows from QUADRANT_ACTUALS
union 
select 'TRIAL_BALANCE' as table_name, count(*) as rows from TRIAL_BALANCE