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 is clusters ?

2 Answers  

What is the difference between truncate & delete command?

0 Answers  

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

0 Answers  

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

Explain self joins in oracle?

0 Answers  

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

What is a Redo Log ?

3 Answers  

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

What are the differences between char and varchar2 in oracle?

0 Answers