SQL Server – All Tables Cursor Query

This is a useful query to list all user tables.

/* SQL Server All Tables Cursor */

--Select name From sysobjects Where xtype = 'U' And Not name In ('dtproperties', 'sysdiagrams') Order By Name

Declare

@TableName varchar(64)
Declare @Sql varchar(1024)
Declare TableCursor Cursor For Select name From sysobjects Where xtype = 'U' And Not name In ('dtproperties', 'sysdiagrams') Order By Name

Open TableCursor
Fetch Next From TableCursor Into @TableName
While @@FETCH_STATUS = 0
Begin
Select @Sql = 'Select Count(*) From ' + @TableName
Print @Sql
--Exec (@Sql)
Fetch Next From TableCursor Into @TableName
End
Close TableCursor
Deallocate TableCursor