Views in SQL

-- Views

view is a logical table.

select    *
from    dbo.TblEmpMaster

create view v_TblEmpMaster as
select    * from dbo.TblEmpMaster

alter view v_TblEmpMaster as
select EmpID from dbo.TblEmpMaster

create view v_TblEmpMasterCn  as
select    * from dbo.TblEmpMaster
where City='Chennai'

create view v_TblEmpMaster  as
select    * from dbo.TblEmpMaster
where Salary<110000 and Gender='Male' and Address='Namakkal'

select    *
from     v_TblEmpMaster

select    *
from     v_TblEmpMasterCn

select    *
from     v_TblEmpMasterCns

drop view v_TblEmpMasterCns

insert ,Delete,update:-
which is also possible in Single View

insert into v_TblEmpMaster values(203,'ggg','Chennai','Male','11/09/2000',6533,'Namakkal','India',897897,'aaa')