what is the syntax of DROP command?

Answer Posted / guest

Drop table tablename;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to increment dates by 1 in oracle?

561


Explain an index segment?

641


How to define a record variable to store a table row?

577


Explain the blob datatype?

618


master table and child table performances and comparisons in Oracle ?

1666






What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1523


How to create a table in a specific tablespace?

543


How to set a transaction to be read only in oracle?

582


Explain the importance of .pll extension in oracle?

555


How to assign a table row to a record variable?

582


Explain a segment?

619


Can we create database in oracle using command line ?

584


How to create lov dynamically at runtime & attach to text field?

662


What is difference between cartesian join and cross join?

590


What is the usage of synonyms?

585