Modifying the Database


Database objects branching down from the default catalog or schema may be examined in finer detail and object alterations may be made.

Tables from the default catalog or schema will display the following items of interest:

  • Table Description
  • Table Constraints
  • Table Indexes
  • Table Privileges
  • Table References
  • Table Data
  • Generated SQL - CREATE TABLE and ALTER TABLE where changes have been made
  • Meta Data - unformatted table column meta data

Editing Database Tables

Database tables from the default schema connection may be altered by making the required changes within the table detail view in the browser's central pane. Specific alterations may be made to table column definitions and table constraints.

Modifications made to any table generates the appropriate ALTER TABLE SQL text. Selecting the SQL tab from the browser's central pane shows the SQL generated and that will be executed on selection of the browser's Apply button.

Note: Most database products maintain their own method of performing table structure modifications. Its is important that the SQL generated by Execute Query be verified prior to execution.

Table columns may be added or dropped by selecting the required column within the table structure display and selecting the appropriate button from the main toolbar.