SQL Create View's

create database Views

use Views

create table Department(Id int,Name varchar(10),Location varchar(20))

insert into Department values(1,'Ahsan','Autralia'),(2,'Ali','America'),(3,'Usama','England')

select * from Department


create view Headview
as
select * from Department

drop view managerview
create view managerview
as
select name from Department

drop view clerkview
create view Clerkview
as
select id from Department


select * from Headview

select * from managerview

select * from Clerkview

                                   Insert & Update View's

insert into Headview values(5,'Akhlas','Canada')

insert into managerview values('Hussain123')

update Headview set id=6,Location='Germany' where name='Hussain123'