如何使CREATE或REPLACE VIEW在SQL Server中工作? [英] How to make CREATE OR REPLACE VIEW work in SQL Server?

问题描述

CREATE OR REPLACE VIEW在SQL Server中似乎不起作用.那么我如何移植CREATE OR REPLACE VIEW在SQL Server上工作?

CREATE OR REPLACE VIEW doesn't seem to work in SQL Server. So how do I port CREATE OR REPLACE VIEW to work on SQL Server?

这就是我想要做的:

CREATE OR REPLACE VIEW data_VVVV AS 
SELECT 
    VCV.xxxx,
        VCV.yyyy AS yyyy,
        VCV.zzzz AS zzzz
FROM 
TABLE_A
;

有什么想法吗?

推荐答案

尽管此问题被标记为重复，但仍在引起注意. @JaKXz提供的答案是正确的，应该是可接受的答案.

您需要检查视图是否存在.然后根据结果执行CREATE VIEW或ALTER VIEW.

You'll need to check for the existence of the view. Then do a CREATE VIEW or ALTER VIEW depending on the result.

IF OBJECT_ID('dbo.data_VVVV') IS NULL
BEGIN
    CREATE VIEW dbo.data_VVVV
    AS
    SELECT VCV.xxxx, VCV.yyyy AS yyyy, VCV.zzzz AS zzzz FROM TABLE_A VCV
END
ELSE
    ALTER VIEW dbo.data_VVVV
    AS
    SELECT VCV.xxxx, VCV.yyyy AS yyyy, VCV.zzzz AS zzzz FROM TABLE_A VCV
BEGIN
END

这篇关于如何使CREATE或REPLACE VIEW在SQL Server中工作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！