can we write a query to check if sqlview exist or not then create view

Question

Hi all,

can somebody help to write a query to check if view present in database , if not then create a view .

For instance :

if  not exists (SELECT * FROM sys.views WHERE OBJECT_ID = OBJECT_ID(N'[abc].[vw_name]')
)
BEGIN
    create view viewname as SELECT    ....... 

END

Answer 1

Hi @Josh

I usually write code like this:

IF OBJECT_ID('View_Stu_Scores')IS NOT NULL
DROP VIEW View_Stu_Scores
GO
CREATE VIEW View_Stu_Scores AS
SELECT UserName,Subject,Score
FROM  StudentScores
WHERE Subject = 'Math'
GO

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Which SQL Server version are you using?

See Update introduces CREATE OR ALTER Transact-SQL statement in SQL Server 2016 as an alternative.

Answer 3

drop VIEW if exists [abc].[vw_name];

go

CREATE or alter VIEW [abc].[vw_name]

AS

SELECT ...