DBMS  QUERIES

create table sy(id int,name varchar(50));

 

 

insert into sy values(1,'sonu');

 

 

insert into sy values(2,'monu');

 

 

insert into sy values(3,'aman');

 

 

 

insert into sy values(4,'geeta');

 

 

 

select * from sy;

 

 

 

create view syco as select id,name from sy;

 

 

select * from syco;

 

 

create table student(s_id int,s_name varchar(20),s_surname varchar(20));

 

 

insert into student values(1,'akash','kale');

 

 

 

insert into student values(1,'pranit','bhalerao');

 

 

 

insert into student values(1,'meena','wagh');

 

 

 

create view stview as select s_id,s_name from student;

 

 

 

select * from stview;

 

 

 

create view stview1 as select s_id,s_name,s_surname from student;

 

 

 

select *from stview1;

 

 

 

drop view stview;

 

 

 

insert into stview1 values (4,'neeta','dole');

 

 

 

select * from stview1;

 

 

 

delete from stview1 where s_id=4;

 

 

 

select * from stview1;

 

 

 

select *from syco, stview1;