SQL server查询所有视图

SELECT Name, Definition FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id WHERE o.[type] = 'v'

注意：本文归作者所有，未经作者允许，不得转载