what is the syntax of DROP command?

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

More Oracle General Interview Questions

What is a proxy object?

0 Answers  


how to retrieve 1st and last row of table without using group functions??

6 Answers  


What is oracle instant client?

0 Answers  


How to find the date and time of last updated table?

4 Answers  


if you ctreate table identity

0 Answers  


find out first highest salary?

10 Answers   Verinon Technology Solutions,


What does `(+)` do in a where clause?

1 Answers  


How to retrieve the count of updated rows?

0 Answers  


What is a tns service name?

0 Answers  


What is background process in Oracle?

0 Answers   MCN Solutions,


How do I uninstall oracle client from windows?

0 Answers  


What is SQL Tuning Advisor in Oracle?

0 Answers   MCN Solutions,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)