Drop

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

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;

Also see

• Delete
• Truncate

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	#