T-SQL :: 枚举所有嵌套视图

要枚举所有嵌套视图，可以使用以下T-SQL代码示例：

-- 创建临时表存储嵌套视图的信息
CREATE TABLE #NestedViews (
    ViewName NVARCHAR(255),
    NestedViewName NVARCHAR(255)
)

-- 递归函数来查找嵌套视图
WITH RecursiveViews (ViewName, NestedViewName, Level) AS (
    SELECT
        OBJECT_NAME(v.object_id) AS ViewName,
        OBJECT_NAME(v2.object_id) AS NestedViewName,
        1 AS Level
    FROM
        sys.views v
    INNER JOIN
        sys.views v2 ON v.definition LIKE '%' + OBJECT_NAME(v2.object_id) + '%'
    
    UNION ALL
    
    SELECT
        rv.ViewName,
        OBJECT_NAME(v2.object_id) AS NestedViewName,
        rv.Level + 1 AS Level
    FROM
        RecursiveViews rv
    INNER JOIN
        sys.views v2 ON rv.NestedViewName = OBJECT_NAME(v2.object_id)
)
INSERT INTO #NestedViews (ViewName, NestedViewName)
SELECT
    ViewName,
    NestedViewName
FROM
    RecursiveViews
WHERE
    Level > 1

-- 查询嵌套视图信息
SELECT * FROM #NestedViews

-- 删除临时表
DROP TABLE #NestedViews

上述代码首先创建了一个临时表#NestedViews来存储嵌套视图的信息。然后使用递归查询来查找嵌套视图，将结果插入临时表中。最后，通过查询临时表来获取所有嵌套视图的信息。最后，记得删除临时表。