select COUNT (*) as 'DataLoadRaw'  from DataLoadRaw
select COUNT (*) as 'DataLoadRawHistory' from DataLoadRawHistory
select COUNT (*) as 'DataLoadRawHistoryArchive' from DataLoadRawHistoryArchive
select COUNT (*) as 'DataLoadFormatted' from DataLoadFormatted
select COUNT (*) as 'DataLoadFormattedHistory' from DataLoadFormattedHistory
select COUNT (*) as 'DataLoadFormattedHistoryArchive' from DataLoadFormattedHistoryArchive

select COUNT(*) as 'DataLoadDaily' from DataLoadDaily
select COUNT(*) as 'DataLoadDailyCFind' from DataLoadDailyCFind
select COUNT(*) as 'DataLoadDailyCaseNotes' from DataLoadDailyCaseNotes
select COUNT(*) as 'DataLoadCallback' from DataLoadCallback
select COUNT(*) as 'DataLoadDailyICS' from DataLoadDailyICS
select COUNT(*) as 'DataLoadLog' from DataLoadLog
select COUNT(*) as 'DataLoadLogRow' from DataLoadLogRow


/*

truncate table DataLoadRaw
truncate table DataLoadRawHistory
truncate table DataLoadRawHistoryArchive
truncate table DataLoadFormatted
truncate table DataLoadFormattedHistory
truncate table DataLoadFormattedHistoryArchive

truncate table DataLoadDaily
truncate table DataLoadDailyCFind
truncate table DataLoadDailyCaseNotes
truncate table DataLoadCallback
truncate table DataLoadDailyICS
truncate table DataLoadLog
truncate table DataLoadLogRow

*/