Answer / guest

Drop table tablename;

Answer / sridevi

drop table <tablename>

Answer / guest

drop table tablebname

Answer / guest

drop table <table name>

Answer / ark chowdary

5. drop table <table name>

Answer / samir kumar sahoo

DROP object <object name>;

object means database object like table,index,view,sequence
etc.

Answer / ravi shrivastava

DROP TABLE TABLENAME

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>;

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

Answer / yeshwanth kumar b.k

hey there is addition to the above command is

DROP TABLE <table_name> [PURGE][CASCADE CONSTRAINTS];

How to invoke the data pump export utility?

0 Answers  

What is the purpose of tables, private synonyms and public synonyms in Oracle?

0 Answers   HCL,

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

Explain the use of Merge statement in oracle 11g

0 Answers   Infosys,

How to run create database statement?

0 Answers  

What is an oracle recycle bin?

0 Answers  

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

how to find the n'th highest salary from emp ?

10 Answers  

What is the difference between count (*), count (expression), count (distinct expression)?

0 Answers  

What is background process in Oracle?

0 Answers   MCN Solutions,

What is the usage of merge statement?

0 Answers  

Explain oracle instance.

0 Answers