Drop

From Oracle FAQ
(Redirected from DROP)
Jump to: navigation, search

DROP is a SQL DDL command that removes an object from the database. One cannot ROLLBACK after executing a DROP statement.

[edit] Examples

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;

[edit] Also see

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 #