单选题删除视图salary的命令是( )。ADROP VIEW salaryBDROP salary VIEWCDELECT salaryDDELECT salary VIEW
单选题
删除视图salary的命令是( )。
A
DROP VIEW salary
B
DROP salary VIEW
C
DELECT salary
D
DELECT salary VIEW
参考解析
解析:
SQL语句中,删除视图的格式为:DROP VIEW<视图名>。
SQL语句中,删除视图的格式为:DROP VIEW<视图名>。
相关考题:
SQL语句中删除视图的命令是( )。 A.DRP TABLEB.DROP VIEWC.ERASE TABLESXB SQL语句中删除视图的命令是( )。A.DRP TABLEB.DROP VIEWC.ERASE TABLED.ERASE VIEW
建立一个视图salary,该视图包括了系号和(该系的)平钧工资两个字段,正确的是SQL语句是A)CREATE VIEW salaryAS系号,AVG(工资)AS平均工资FROM教师;GROUP BY系号B) CREATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师;GROUP BY系名C) CREATE VIEW salary SELECT系号,AVG(工资)AS平均工资FROM教师;GROUP BY系号D)CREATE VIEW salary AS SELECT系号,AVG(工资)As平均工资FROM教师;GROUP BY系号
删除视图STUDENT的命令是( )。A.DELETE STUI)ENT VIEWB.DELETE STUI)ETNC.DROP STUDENT VIEWD.DROP VIEW STUDENT
SQL语句中删除视图的命令是( )。A.DRP TABLE B.DROP VIEW C.ERASE TABLE S SQL语句中删除视图的命令是( )。A.DRP TABLEB.DROP VIEWC.ERASE TABLED.ERASE VIEW
建立一个视图salary,该视图包括了系号和(该系的)平均工资两个字段,正确的SQL语句是:A.CREATE VIEW salary AS系号,SVG(工资)AS平均工资FROM教师GROUP BY系号B.CREATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师GROUP BY系名C.CREATE VIEW Salary SELECT系号,AVG(工资)AS平均工资FROM教师GROUP BY系号D.CREATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师GROUP BY系号
下面语句中,()语句用来修改视图。A、CREATE TABLEB、ALTER VIEWC、DROP VIEWD、CREATE VIEW