希望这能解决问题.如果没有,请告诉我.
请指导!谢谢!
select cols.* from sys.sql_expression_dependencies objs outer apply sys.dm_sql_referenced_entities ( OBJECT_SCHEMA_NAME(objs.referencing_id) + N'.' + object_name(objs.referencing_id),N'OBJECT' ) as cols where objs.referencing_id = object_id('view_name_here')
参考:sys.dm_sql_referenced_entities (Transact-SQL) .