SQL Server traverses all tables in the database and the total number of statistical tables:
Code
1 declare @ tablename varchar (255 );
2 create table # getrecordingtemptable ([ID] [int] Identity (1,1) not null, [tablename] varchar (255) not null, [recordingcount] INT );
3 declare table_cursor cursor for select [name] From sysobjects where xtype = 'U ';
4 open table_cursor;
5 fetch next from table_cursor into @ tablename;
6 While (@ fetch_status = 0)
7 begin
8 exec ('insert into # getrecordingtemptable ([tablename], [recordingcount]) Select ''' + @ tablename + ''', count (0) from ['+ @ tablename +']; ');
9 fetch next from table_cursor into @ tablename;
10 end
11 close table_cursor;
12 deallocate table_cursor;
13 select [tablename] as [Table name], [recordingcount] as [total number of records] From # getrecordingtemptable order by [recordingcount] DESC;
14 drop table # getrecordingtemptable;
15 go
