SqlServer 查看数据库中所有视图

时间：2024-03-12 12:49:10

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\'

相关文章

