查詢View和表格
SELECT
OBJECT_SCHEMA_NAME(v.object_id) schema_name,
v.name
FROM
sys.views as v
order by name
SELECT
OBJECT_SCHEMA_NAME(v.object_id) schema_name,
v.name
FROM
sys.tables as v
order by name
獲取所有View腳本，但是必須有權(quán)限
SELECT
name,
OBJECT_DEFINITION(object_id) AS definition
FROM
sys.views
