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='三建'