Views :
- A View is nothing more than a saved SQL query. A view can be considered as virtual table
- A view can have a maximum of 1,024 columns.
- If we Insert or Delete from view than this will also effect on our Actual Table
- If a trigger is set on a table and we perform DML operations on that table by views than trigger will be called
Syntax for creating view
create view myview1
AS
select * from test1
Syntax for Dropping View
drop view myview1
Syntax to use View
select * from
myview1