Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of DROP command?
- 10 Answers
- 13103 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
DROP object <object name>;
object means database object like table,index,view,sequence
etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ruchika jena
If u want to drop a table then the command is
drop table <table_name>;
If u want to drop a column_name then the command is
alter table <table_name> drop column <column_name>;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ch.ramesh
Drop is used to drop the total table
from data base
syntax: drop table <tablename>
note: there is no rollback command for drop
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / yeshwanth kumar b.k
hey there is addition to the above command is
DROP TABLE <table_name> [PURGE][CASCADE CONSTRAINTS];
| Is This Answer Correct ? | 0 Yes | 0 No |
How are extents allocated to a segment?
What happens to the current transaction if a ddl statement is executed?
What is an oracle?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How many types of tables supported by oracle?
what is the syntax of DROP command?
How to loop through a cursor variable?
What is Oracle table?
What is tns name?
Differentiate between function and procedure in oracle.
In oracle there is column command, how will you explain that?
How to get execution statistics reports on query statements?
Oracle General 
