Introduction

 Previous  Index  Next  How To Use

Each type of object has it's own special Object Editor in Database Workbench. These editors are database engine and version specific - so if you're using multiple database engines with Database Workbench, the editors may differ between them.

 

For a short introduction on the Object Editor user interface and layout of the editors in general, see Getting Started - Object Editors.

 

The Object Editors will also check for reserved keywords and SQL 92/99 standard keywords and depending on your database engine capabilities, it will issue a warning or an error, before sending the create statements to the server.

 

The following editors are available:

 

•SQL Editor
•Script Editor

 

The following Schema Object Editors are available:

 

•Domain Editor
•Table Editor
•View Editor
•Materialized View Editor
•Stored Procedure Editor
•Stored Function Editor
•Package Editor or Stored Module Editor
•Trigger Editor
•Type Editor
•Collection Type Editor
•Index Editor
•Constraint Editor
•Sequence Editor or Generator Editor
•Exception Editor
•External Function Editor
•Synonym Editor or Alias Editor
•Java Source Editor
•Enum Type Editor
•Library Editor
•Change View Subscription Editor

 

The following Database Objects Editors are available:

•Assembly Editor
•(Scheduled) Job Editor
•Database Trigger Editor
•Database Schema Editor
•Tablespace Editor
•Remote Server Editor

 

The following Security Object Editors are available:

•Role Editor
•User Editor
•Group Editor
•Login Policy Editor
•Encryption Key Editor
•LDAP Server Editor

 

The access to the editors depends on server brand and version.