Drop is used to drop the total table from data base syntax: drop table

what is the syntax of DROP command?

Question Posted / ch.ramesh

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is the difference between substr and instr function in oracle?

1090

How to write text literals in oracle?

1067

What are the execution control statements?

1063

How many types of tables supported by oracle?

1076

What is the difference between post-database commit and post-form commit?

1195

Explain implicit cursor.

1027

How to use "in out" parameter properly?

1046

11. Display the client number and name and the client number and name of the person who referred that client.

2339

What is oracle datasource?

984

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1045

How do I escape a reserved word in oracle?

1197

How does one get the view definition of fixed views/tables?

1021

Explain oracle 12c new features for developers?

1058

How to create a table in a specific tablespace?

974

What is a lookup table in oracle?

973