Drop
From Oracle FAQ
DROP is a SQL DDL command that removes an object from the database. One cannot ROLLBACK after executing a DROP statement.
Examples[edit]
Drop tables:
DROP TABLE emp;
DROP TABLE emp CASCADE CONSTRAINTS;
Drop sequences:
DROP SEQUENCE seq1;
Drop views:
DROP VIEW view1;
Drop synonyms:
DROP SYNONYM syn1;
Drop a database user:
DROP USER user1 CASCADE;
Drop a tablespace:
DROP TABLESPACE ts1 INCLUDING CONTENTS AND DATAFILES;
Also see[edit]
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
