查询系统表

最新推荐文章于 2021-09-08 11:25:02 发布

吉普赛的歌

最新推荐文章于 2021-09-08 11:25:02 发布

阅读量305

点赞数

分类专栏： # 常用代码

本文链接：https://blog.csdn.net/yenange/article/details/79472090

版权

常用代码专栏收录该内容

93 篇文章 3 订阅

订阅专栏

;WITH cte AS (
SELECT tbl.*,
       CAST(
           CASE 
                WHEN tbl.is_ms_shipped = 1 THEN 1
                WHEN (
                         SELECT major_id
                         FROM   sys.extended_properties
                         WHERE  major_id     = tbl.object_id
                                AND minor_id = 0
                                AND class = 1
                                AND NAME     = N'microsoft_database_tools_support'
                     ) 
                     IS NOT NULL THEN 1
                ELSE 0
           END 
           AS BIT
       )           AS [IsSystemObject]
FROM   sys.tables  AS tbl
)
SELECT * FROM cte WHERE IsSystemObject=1