Monday, February 2, 2015

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
select * from test1

Syntax for  Dropping View

drop view myview1

Syntax to use View

select * from myview1