Creating / Updating View Using Stored Procedure

I want to create or update a view using stored procedure like this: CREATE PROC Proc_Get_Ready_Weapons AS BEGIN IF EXISTS(select * FROM sys.views where name = 'dbo.vwGetReadyWea

Solution 1:

CREATE OR REPLACE is not valid in SQL Server (at least not yet).

Perhaps you meant:

EXEC('ALTER VIEW dbo. ...');

You also don't have a valid check. I think you meant:

IF NOT EXISTS 
  (SELECT 1 FROM sys.views WHERE [object_id] = OBJECT_ID('dbo.vwGetReadyWeapons'))