您可以使用
sys.sql_dependencies:
select object_name(object_id),* from sys.sql_dependencieswhere referenced_major_id = object_id('<tablename>');
这将列出所有依赖于表的对象,您可以通过加入反对将其限制为视图
sys.views:
select v.* from sys.sql_dependencies djoin sys.views v on d.object_id = v.object_idwhere referenced_major_id = object_id('<tablename>');
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)