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

Explain the difference between sap and oracle?

0 Answers  

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

0 Answers  

What are the composite date types in oracle?

6 Answers   HCL,

Why we use bulk collect in oracle?

0 Answers  

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

0 Answers  

difference between imlicit cursor and explicit cursor ?

5 Answers   Cap Gemini,

What is ceil and floor in oracle?

0 Answers  

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

What are the uses of a database trigger?

0 Answers  

What is archive log in Oracle?

0 Answers   MCN Solutions,

select * from emp what happened internally when we write this query in the sql prompt?

5 Answers  

What to do if dba lost the system password?

0 Answers