Oracle cheat sheets commands part-ix

1)drop procedure

DROP PROCEDURE my_proc;

2)drop profile

DROP PROFILE my_profile CASCADE;

3)drop role

DROP ROLE my_role;

4)drop rollback segment

DROP ROLLBACK SEGMENT rbs01;

5)drop sequence

DROP SEQUENCE my_seq;

6)drop synonym

DROP SYNONYM my_synonym;
DROP PUBLIC SYNONYM my_synonym;

7)drop table

DROP TABLE my_tab;
DROP TABLE my_tab CASCADE CONSTRAINTS;
DROP TABLE my_tab CASCADE CONSTRAINTS PURGE;

8)drop tablespace

DROP TABLESPACE my_tbs;
DROP TABLESPACE my_tbs INCLUDING CONTENTS;
DROP TABLESPACE my_tbs INCLUDING CONTENTS
AND DATAFILES CASCADE CONSTRAINTS;

9)drop trigger

DROP TRIGGER my_trigger;

10)drop user

DROP USER my_user CASCADE;