Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of DROP command?
- 10 Answers
- 13547 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 |
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What is the quickest way to fetch the data from a table?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What is the difference between a primary key & a unique key?
What are the different windows events activated at runtime ?
what is trigger?
What are the uses of synonyms?
Explain index?
What is using clause and give example?
which is the best training centre for learning oracle?
can we insert any row to dual table if i got the permission from DBA
how many columns can a plsql table have
Oracle General 
