ddd

---10.
delete from ShanJian_View
where sno='s1' 
--（11）
create view S_Sname_View cascade
as select sname 
from S_View 
with check option
---（12）


sp_rename S_view,SS_View
--（13）
alter view SS_view
as select sno,sname,'上海' city
from s 
--（14）
drop view ss_view
--（15）


into ss_view
drop view s_view cascade 
select * from SS_View
select * from S_Sname_View                                                                                                                                                                                                                         
drop view s_view S_Sname_View 
create view S_View 
as select sno,sname
from s
with check option
create view ShanJian_View
as select sno,pno,qty
from spj
where jno =(
select jno 
from j
where jname='三键'
)
select * from ShanJian_View
select * from j
update j
set jname='三键'
where j.jname='三建'