SQL Alter View
View is a virtual and imaginary table come out as result -set of an SQL statement. A virtual table contains rows and columns, as same as real table. In SQL Alter View is used to modify a previous created view. The advantage of Alter View hardly any effect on dependent procedure, trigger and change permissions.
Understand with Example
The Tutorial illustrates an example from SQL Alter View. In this Tutorial, we want to describe you how to alter a created view. For, this we create a table 'Stu_Table' using create statement. The insert into add the records or rows to the created table'Stu_Table'.The select statemet return you all the record added by the insert into statement.
Create Table Stu_Table
Insert data into Stu_Table
Now we create a view of table 'Stu_Table'. The view "Stu_View" lists all the field from the "Stu_View" table. The view can be created with the help of given SQL Query.
You can see the created view "Stu_View" using View Stu_View statement.
The Alter View modify the existing created view Stu_View. The ALTER VIEW statement is used to modify the Stu_View enlisted all the list of field selected in select query. The WHERE clause restrict the select query and return you the record based upon condition whose stu_Id is less than equal to'5'.