Modifying a View

Syntax:: ALTER VIEW view_name [ ( column1, ... ) ]
[ WITH ENCRYPTION ]
AS
select_statement
[ WITH CHECK OPTION ]

A View can be modified by:

Deleting the existing view and creating a new one.
Using the ALTER VIEW T-SQL command.

Modifying a view does not change any of the dependents on the view, but the dependents are lost when a view is recreated. The parameters from the ALTER VIEW statement are the same as those for the CREATE VIEW statement.

Examples

Code:


			ALTER VIEW vwStudentDetails

			AS

			SELECT * FROM Students

			WHERE Std_Grade=1;
			
			



			
			SELECT * FROM vwStudentDetails;

Output:


			The command(s) completed successfully.
			
			



			
			
				Id Name Std_Course Phone Std_Grade
				
				3 Harri Robins 3 78788 1
				 
			
			(1 row(s) affected)

Id	Name	Std_Course	Phone	Std_Grade
3	Harri Robins	3	78788	1

Explanation:

This example alters the view created earlier, and then executes it.

Primary links

T-SQL » Views » Modifying a View

Examples

Code:

Output:

Explanation:

Language(s): MS SQL Server