Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of DROP command?
- 10 Answers
- 13571 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 |
What is dictionary cache ?
Explain the use of indexes option in imp command.
what is difference between foreign key and reference key
how do get database name at sql prompt?
What is the quickest way to export a table to a flat file?
How to define a data source name (dsn) in odbc manager?
How to bring a tablespace online?
How to manage transaction isolation level?
What is redo log?
How to handle a single quote in oracle sql?
How would you change old and new values in an insert, delete and update triggers?
What do you understand by a database object? Can you list a few of them?
Oracle General 
