Online Documentation for SQL Manager for Oracle

Schema objects

A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user. Each user can own a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects:

• Tables
• Views
• Procedures
• Functions
• Triggers,
• DB and Schema Triggers
• Indexes
• Packages, Package Bodies
• Sequences
• Clusters
• Materialized Views, Materialized View Logs
• Synonyms
• Database Links
• Object Types, Object Type Bodies
• Array Types
• Libraries
• Java Sources, Java Classes, Java Resources
• Index Types
• Operators
• Dimensions
• Queues
• Queue Tables

Use the DB Explorer tree to navigate within the existing schemas and their objects.