How to Update View in SQL Server 2005

Question

I want to update the existing view without dropping it, can you just provide me the syntax how to do it..?

Existing view:

CREATE VIEW V1 AS SELECT EMP_ID,NAME FROM EMP_TABLE

I want to update V1 as:

SELECT EMP_ID,NAME, SALARY WHERE SALARY>10000

Answer 1

It's as simple as:

ALTER VIEW V1 AS
  SELECT EMP_ID,NAME, SALARY WHERE SALARY > 10000;

Answer 2

If you forget this in the future, you can always right click on the view in SQL Server Management Studio and select 'Modify' this will give you the current query, with the correct syntax for altering it.