Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of DROP command?
- 10 Answers
- 13820 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 |
without using count(*) and rownum how can we count total record in a table
How to best split csv strings in oracle 9i?
Difference between cartesian join and cross join?
Explain the use of record option in exp command.
What is catalog in Oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is system tablespace?
What would you do with an in-doubt distributed transaction?
What is difference between SUBSTR and INSTR?
What is oracle instant client?
How do you store pictures in a database?
What are the arithmetic operations?
Oracle General 
