1. 生成脚本:
SELECT 'select '''+TABLE_SCHEMA + '.[' + TABLE_NAME + ']'' as TblName, count(1) as Cnt from ' + TABLE_SCHEMA + '.[' + TABLE_NAME + '] union'
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE';
1. 生成脚本:
SELECT 'select '''+TABLE_SCHEMA + '.[' + TABLE_NAME + ']'' as TblName, count(1) as Cnt from ' + TABLE_SCHEMA + '.[' + TABLE_NAME + '] union'
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE';