Creating, Editing, and Dropping Schema Objects

Create, edit, or drop (delete from the database) a variety of online database schema objects:

Object	Create	Edit	Drop
User name	Creating Users	SQL Worksheet	SQL Worksheet
Functions (PL/SQL)	Creating PL/SQL Functions	Editing PL/SQL Programs	Dropping Schema Objects
Java Classes	N/A	N/A	N/A
Materialized View Logs	SQL Worksheet	SQL Worksheet	SQL Worksheet
Materialized Views	SQL Worksheet	SQL Worksheet	SQL Worksheet
Object Types	SQL Worksheet	Editing Other Database Objects	Dropping Schema Objects
Packages and Package Bodies	Creating PL/SQL Packages	Editing PL/SQL Programs	Dropping Schema Objects
Procedures	Creating PL/SQL Procedures	Editing PL/SQL Programs	Dropping Schema Objects
Sequences	SQL Worksheet	SQL Worksheet	SQL Worksheet
Tables	Creating Tables	Editing Tables	Dropping Schema Objects
Triggers	Creating PL/SQL Triggers	Editing PL/SQL Programs	Dropping Schema Objects
Views	Creating Views	SQL Worksheet	SQL Worksheet

You can also create, edit, and delete offline tables and views. See Working with Offline Database Definitions for information.