sql-server - SQL 服务器 : create view if not exists don't work

Question

如果 View 不存在，我正在尝试使用:

IF OBJECT_ID('dbo.zestaw_zam_fak') IS NULL 
   CREATE VIEW AS 
       SELECT .... 
       FROM .... 
       UNION 
       SELECT ..... 
       FROM.... 
       UNION 
       SELECT ... 
       FROM ... 

但是我得到一个错误:

Unable to parse query text
Incorrect syntax near the keyword VIEW.

没有语句 'IF OBJECT_ID('dbo.zestaw_zam_fak') IS NULL， View 创建正确。

我做错了什么？

Answer 1

您必须将 CREATE 语句包装到 EXEC('your create statement') 中。否则它不会在 IF

中工作

示例:

IF OBJECT_ID('dbo.vwCity') IS NULL
BEGIN   
    EXECUTE('CREATE VIEW [dbo].[vwCity]
    AS
    SELECT  *
    FROM  dbo.City')
END