显示sql server数据库所有的表

DECLARE tnames_cursor CURSOR FOR   
SELECT TABLE_NAME   FROM INFORMATION_SCHEMA.TABLES   
OPEN tnames_cursor
DECLARE @tablename sysname
FETCH NEXT FROM tnames_cursor INTO @tablename
WHILE (@@FETCH_STATUS <> -1)
BEGIN   IF (@@FETCH_STATUS <> -2)   
BEGIN        SELECT @tablename = RTRIM(@tablename)      EXEC ('SELECT * FROM ' + @tablename )    
 PRINT ' '   END   
FETCH NEXT FROM tnames_cursor INTO @tablename
END
CLOSE tnames_cursor
DEALLOCATE tnames_cursor

 

评论

3 楼 zhiyongliu 2015-11-16  

nba2k 写道

看不懂，老师

nba2k 写道

看不懂，老师

其实我也看不懂，就知道怎么用就好了

2 楼 nba2k 2015-11-14  

看不懂，老师

1 楼 nba2k 2015-11-14