更多"删除视图myview的命令是______。"的相关试题:
[单项选择]删除视图myview的命令是( )。
A. DELETE myview
B. DELETE VIEW myview
C. DROP VIEW myview
D. REMOVE VIEW myview
[单项选择]根据“歌手”表建立视图myview,视图中含有“歌手号”左边第一位是“1”的所有记录,正确的SQL语句是( )。
A. CREATE VIEW myview AS SELECT*FROM歌手WHERE LEFT(歌手号,1)="1"
B. CREATE VIEW myview AS SELECT*FROM歌手WHERE LIKE("1",歌手号)
C. CREATE VIEW myview SELECT*FROM歌手WHERE LEFT(歌手号,1)="1"
D. CREATE VIEW myview SELECT*FROM歌手WHERE LIKE("1",歌手号)
[单项选择]SQL语句中删除视图的命令是( )。
A. DROP TABLE
B. DROP VIEW
C. ERASE TABLE
D. ERASE VIEW
[单项选择]删除视图stuvw的命令是( )。
A. DROP stuvw
B. DROP VIEW stuvw
C. DELETE stuvw
D. DELETE VIEW stuvw
[单项选择]删除视图STUDENT的命令是( )。
A. DELETE STUDENT VIEW
B. DELETE STUDETN
C. DROP STUDENT VIEW
D. DROP VIEW STUDENT
[单项选择]删除视图salary的命令是( )。
A. DROP salary VIEW
B. DROP VIEW salary
C. DELETE salary VIEW
D. DELETE salary