SQL 创建视图

http://wenku.baidu.com/view/3fa7e83a580216fc700afd22.html
数据库高级语句
-----------------------------------------------------------------
http://www.yesky.com/imagesnew/software/tsql/ts_create2_30hj.htm
-----------------------------------------------
USE pubs
IF EXISTS
 (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
      WHERE TABLE_NAME = 'titles_view')
   DROP VIEW titles_view
GO
CREATE VIEW titles_view
AS
   SELECT title, type, price, pubdate FROM titles
GO