查看视图view_vw代码:
sp_helptext
sys.modules 元数据函数
exec sp_helptext view_vw;
select * from sys.sql_modules
where object_id = object_id('dbo.ciew_vw');
加密视图: with encryption
alter/create view view_vw with encryption
……
通过with check option限制插入到视图中的内容
模式绑定视图
创建视图索引:
alter/create view view_vw with schemabinding
……