what is the syntax of DROP command?

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

What is oracle join syntax?

725


What is oracle open database communication (odbc)?

738


Use of an integrity constraint is better to validate data. Explain

761


What is a nvl function? How can it be used?

743


What is system global area (sga) in oracle?

765


How to view the tablespaces in the current database?

738


What is a Garbage Collection? and what is full recursive Garbage collection?

2581


How to display employee records who gets more salary than the average salary in the department?

797


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

738


How many types of tables are there in oracle?

792


How to set up autotrace for a user account?

777


What are the original export and import utilities?

746


How do I recompile a procedure in oracle?

704


How to create a new tablespace in oracle?

725


How to display row numbers with the records?

786