what is the syntax of DROP command?
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 |
Which dictionary tables and/or views would you look at to diagnose a locking issue?
what is a view?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
How to drop a tablespace?
In which language oracle has been developed?
How to filter out duplications in the returning rows using oracle?
What happens to the data files if a tablespace is dropped?
How to get the Installed Oracle Version Information ?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What are different Oracle database objects?
Can we write insert statement in function in oracle?
Explain oracle data types with examples?