what is the syntax of DROP command?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / ppp

10 Answers
13476 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the syntax of DROP command?..

Answer / guest

Drop table tablename;

Is This Answer Correct ?

6 Yes

0 No

what is the syntax of DROP command?..

Answer / sridevi

drop table <tablename>

Is This Answer Correct ?

4 Yes

0 No

what is the syntax of DROP command?..

Answer / guest

drop table tablebname

Is This Answer Correct ?

2 Yes

0 No

what is the syntax of DROP command?..

Answer / guest

drop table <table name>

Is This Answer Correct ?

2 Yes

0 No

what is the syntax of DROP command?..

Answer / ark chowdary

5. drop table <table name>

Is This Answer Correct ?

2 Yes

0 No

what is the syntax of DROP command?..

Answer / samir kumar sahoo

DROP object <object name>;

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

Is This Answer Correct ?

1 Yes

0 No

what is the syntax of DROP command?..

Answer / ravi shrivastava

DROP TABLE TABLENAME

Is This Answer Correct ?

1 Yes

0 No

what is the syntax of DROP command?..

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

Is This Answer Correct ?

1 Yes

0 No

what is the syntax of DROP command?..

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

Is This Answer Correct ?

0 Yes

0 No

what is the syntax of DROP command?..

Answer / yeshwanth kumar b.k

hey there is addition to the above command is

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer