显示sql server数据库所有的表

最新推荐文章于 2024-08-14 02:58:23 发布

lzy600

最新推荐文章于 2024-08-14 02:58:23 发布

阅读量792

点赞数

分类专栏： database 文章标签：数据库

本文链接：https://blog.csdn.net/lzy600/article/details/84357737

版权

database 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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