来自「数据库系统概论中所有的数据库例子以及课后习题和最后的上机实习的数据库。薛数据库的」· 代码 · 共 13 行

/*[例16]  删除视图CS_S中学号为95029的记录
DELETE
FROM IS_Student
WHERE Sno= '95029'
转换为对基本表的更新：
DELETE
FROM Student
WHERE Sno= '95029' AND Sdept= 'IS'
*/

DELETE
FROM Student
WHERE Sno= '95029' AND Sdept= 'IS'