SqlServer教程

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

本文主要是介绍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)

 

这篇关于SQL Server ->> 查找数据库表\字段被哪些编程对象架构绑定了(SHEMA_BINDING)的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!