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

What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

How to define a sub function?

0 Answers  

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

What is a Redo Log ?

3 Answers  

What is the exact use of Collections?

0 Answers  

What is bulk load in oracle?

0 Answers  

How to export data with a field delimiter?

0 Answers  

How to get a list of all user accounts in the database?

0 Answers  

How to login to the server without an instance?

0 Answers  

what is the difference between sql& oracle?

11 Answers   Oracle,