如何在MSSQL上创建或更改视图？ [英] How do I create or alter view on MSSQL?

问题描述

我需要写一个查询创建一个视图（如果不存在），如果存在则需要更改视图（不删除并重新创建）


我尝试过的事情：



我在许多网站上搜索过。大多数时候我发现只丢弃并重新创建视图。

解决方案

首先尝试使用文档： ALTER VIEW（Transact-SQL） [ ^ ]

  IF   NOT   EXISTS （ select  *  FROM  sys.views 其中 name = '  data_VVVV'）
  BEGIN  
  CREATE   VIEW  data_VVVV  AS  
  SELECT  VCV.xxxx，VCV.yyyy  AS  yyyy，VCV.zzzz  AS  zzzz  FROM  TABLE_A VCV 
  END  
  ELSE  
  BEGIN  
  ALTER   VIEW  data_VVVV  AS  
  SELECT  VCV.xxxx，VCV.yyyy  AS  yyyy ，VCV.zzzz  AS  zzzz  FROM  TABLE_A VCV 
  END  

I need to write a query to create a view if not exist already and if exist then need to alter view (not dropping and recreate) in MSSQL. Can someone help me?

What I have tried:

I searched in many websites. Most of times i found only dropping and recreate the view.

解决方案

Try with the documentation first : ALTER VIEW (Transact-SQL)[^]

IF NOT EXISTS(select * FROM sys.views where name = 'data_VVVV ')
    BEGIN
        CREATE VIEW data_VVVV AS 
        SELECT VCV.xxxx, VCV.yyyy AS yyyy, VCV.zzzz AS zzzz FROM TABLE_A VCV
    END
ELSE
    BEGIN
        ALTER VIEW data_VVVV AS 
        SELECT VCV.xxxx, VCV.yyyy AS yyyy, VCV.zzzz AS zzzz FROM TABLE_A VCV
    END

这篇关于如何在MSSQL上创建或更改视图？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！