How to add new column in existing View in SQL-Server 2014 using Alter

sql sql-server view alter
SPBeginer picture SPBeginer · Sep 16, 2016 · Viewed 87k times · Source

I have created a view that is based on another view and a table. I want to add new column of type varchar. I did like below, But getting syntax error? I am new to SQL, So,could not understand

ALTER VIEW [dbo].[MyView]
ADD New_Col varchar(10) null 
GO

Answer

GuidoG picture GuidoG · Sep 16, 2016

you have to write the entire view again and just add or omit what you want to change

for example your view is now :

create view myView as
  select field1
  from table1

and now you want to add a field called New_Col than you write this :

alter view myView as
  select field1,
         New_Col
  from table1

Related questions

How can I check if a View exists in a Database?

I have some SQL code that needs to be executed if a certain View exists in a database. How would I go about checking if the View exists? EDIT: The DBMS being used is Microsoft SQL Server

Read More
How to make CREATE OR REPLACE VIEW work in 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? This is what I'm trying to do: CREATE OR REPLACE VIEW data_VVVV AS SELECT …

Read More
Drop view if exists

I have script where I want to first drop view and then create it. I know how to drop table: IF EXISTS (SELECT * FROM sys.tables WHERE name = 'table1' AND type = 'U') DROP TABLE table1; so I did the …

Read More