DECLARE @TabName VARCHAR(100)
DECLARE test_Cursor CURSOR LOCAL FOR SELECT Name FROM SysObjects Where XType='U' ORDER BY Name
OPEN test_Cursor
FETCH NEXT FROM test_Cursor INTO @TabName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @TabName;
FETCH NEXT FROM test_Cursor INTO @TabName
END
CLOSE test_Cursor
DEALLOCATE test_Cursor