更多"删除视图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",歌手号)
[单项选择]删除视图salary的命令是
A. DROP salary VIEW
B. DROP VIEW salary
C. DELETE salary VIEW
D. DELETE salary
[单项选择]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
[单项选择]在Project 2003中,用户可以在“______”菜单中选择不同的视图命令来切换到对应的视图。
A. 插入
B. 视图
C. 工具
D. 格式
[单项选择]在SQL中,删除视图用
A. DROP SCHEMA命令
B. CREATE TABLE命令
C. DROP VIEW命令
D. DROP INDEX命令