以下能删除表的语句是( )
A: Delete * from emp
B: Drop database emp
C: Drop * from emp
D: delete database emp
A: Delete * from emp
B: Drop database emp
C: Drop * from emp
D: delete database emp
举一反三
- 下面删除记录的语句正确的是( ) A: delete from emp where name="Tony"; B: delete * from emp where name="Tony"; C: drop from emp where name="Tony"; D: drop * from emp where name="Tony";
- 删除数据库Test的正确SQL语句是（ ） A: Drop DataBase Test B: Delete DataBase Test C: Alter DataBase Test D: Delete From DataBase Test
- 删除数据库，表使用的关键字是drop还是delete？_________________。删除表“emp”中的所有数据使用命令：_________________________________。
- 下列删除itcast数据库的sql语句中，正确的是（ ）。 A: DROP TABLE itcast; B: DELETE DATABASE itcast; C: DROP DATABASE itcast; D: DELETE FROM DATABASE itcast;
- 以下语句不正确的是( ) A: select * from emp; B: select ename,hiredate,sal from emp; C: select * from emp order deptno; D: select * from where deptno=1