CREATE OR REPLACE VIEW
在SQL Server中似乎不起作用.那么,如何在SQL Server上使用端口CREATE OR REPLACE VIEW
呢?
这就是我想做的:
CREATE OR REPLACE VIEW data_VVVV AS
SELECT
VCV.xxxx,
VCV.yyyy AS yyyy,
VCV.zzzz AS zzzz
FROM
TABLE_A
;
有什么 idea 吗?
CREATE OR REPLACE VIEW
在SQL Server中似乎不起作用.那么,如何在SQL Server上使用端口CREATE OR REPLACE VIEW
呢?
这就是我想做的:
CREATE OR REPLACE VIEW data_VVVV AS
SELECT
VCV.xxxx,
VCV.yyyy AS yyyy,
VCV.zzzz AS zzzz
FROM
TABLE_A
;
有什么 idea 吗?
Edit: Although this question has been marked as a duplicate, it has still been getting attention. The answer provided by @JaKXz is correct and should be the accepted answer.
您需要判断视图是否存在.然后根据结果做CREATE VIEW
或ALTER VIEW
.
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