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 can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

0 Answers  

How do you find current date and time in oracle?

0 Answers  

what is the syntax of ALTER command?

8 Answers  

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

2 Answers   Oracle, SAH,

how to we delete a row using varray

3 Answers   CTC,

find out the second highest salary?

55 Answers   Cognizant, Nucsoft, Oracle, TCS, Wondersoft,

Is oracle a programming language?

0 Answers  

What is instant client oracle?

0 Answers  

How to create a new view in oracle?

0 Answers  

What is a heap related to database ?

1 Answers   TCS, University of Edinburgh,

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

What are the differences between lov and list item?

0 Answers