Drop

From Oracle FAQ
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.

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 #