查看视图结构 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
查看视图结构 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