hey there is addition to the above command is DROP TABLE <table

what is the syntax of DROP command?

Question Posted / yeshwanth kumar b.k

10 Answers
13488 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

List the parts of a database trigger.

1047

How to set up autotrace for a user account?

1054

Explain how are indexes update?

1060

What is an oracle data file?

1101

How do I spool to a csv formatted file using sqlplus?

1026

What is the data pump import utility?

1029

Explain the difference between sap and oracle?

1029

how do u setup a replication site?

1977

Explain the features of oracle?

1038

How to use in conditions in oracle?

1050

Explain the use of record option in exp command.

999

How to create a temporary table in oracle?

1262

What is MTTR advisor in Oracle?

1088

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2318

Explain the truncate in oracle?

963