About SQL Views

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