numberCounter.sql

DROP TABLE IF EXISTS #temp_tablelist

CREATE TABLE #temp_tablelist(
  [table_name] [nvarchar](50) NOT NULL,
  [rec] integer NOT NULL
)

DECLARE table_cursor CURSOR FOR 
  SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
DECLARE @table_name AS NVARCHAR(50)
OPEN table_cursor
  FETCH NEXT FROM table_cursor INTO @table_name
  WHILE @@FETCH_STATUS = 0
  BEGIN
    EXECUTE ('insert into #temp_tablelist select ''' + @table_name + ''' ,count(*) from ' + @table_name)
    FETCH NEXT FROM table_cursor INTO @table_name
  END
CLOSE table_cursor
DEALLOCATE table_cursor

select * from #temp_tablelist order by table_name