SQL语法——视图创建

/*    视图*//*-- 1. 定义视图        CREATE VIEW view_name [(列名[,列名]...)]        AS 子查询 [with check option]*/--e.g.     --定义视图compStud为计算机系的学生，通过该视图可以将student表中其他系的学生屏蔽    CREATE VIEW comStud AS        (SELECT * FROM student WHERE d# IN             (SELECT d# FROM dept WHERE dname = '计算机')        );