SQL Server 视图篇

查看视图结构 

1: select text from syscomments where id=object_Id('视图名')
2: sp_helptext 视图名

创建视图
1：
create view View_EdsProd 
as
   select * from Tab_EdsProd where Mid>1
go

SQL 撤销视图
SQL DROP VIEW Syntax
DROP VIEW view_name