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 |
What is a proxy object?
how to retrieve 1st and last row of table without using group functions??
What is oracle instant client?
How to find the date and time of last updated table?
if you ctreate table identity
find out first highest salary?
10 Answers Verinon Technology Solutions,
What does `(+)` do in a where clause?
How to retrieve the count of updated rows?
What is a tns service name?
What is background process in Oracle?
How do I uninstall oracle client from windows?
What is SQL Tuning Advisor in Oracle?