SQL Server ->> 查找数据库表\字段被哪些编程对象架构绑定了(SHEMA_BINDING)

 

SELECT OBJECT_SCHEMA_NAME(dep.referencing_id) AS [schema]
        ,referencing_entity.name
        ,CASE referencing_entity.type 
            WHEN 'V' THEN N'VIEW'
            ELSE /*IF, FN, TF*/ N'FUNCTION'
        END as [type]
FROM sys.sql_expression_dependencies AS dep
    INNER JOIN sys.objects AS referencing_entity 
        ON dep.referencing_id = referencing_entity.object_id
WHERE dep.referenced_entity_name = @EntityName 
        AND dep.referenced_schema_name = @SchemaName 
        AND is_schema_bound_reference = 1
        AND ((@ColumnName IS NULL AND dep.referenced_minor_id = 0) OR COL_NAME(dep.referenced_id, dep.referenced_minor_id) = @ColumnName)

 

上一篇:服务器重启后 Nvidia 环境错误


下一篇:Spark的Driver和Executor