Table Visual Editor

One of the most useful purposes of visual editing is to create and alter tables. In Aqua Data Studio 7, you’ll save time setting up tables and properties without ever having to remember the DDL and options for each database you use. The redesigned visual editor for tables includes complete options for all tables across all databases, including comments, permissions, storage options and extended properties for columns and constraints. All these options can be categorized, sorted and expanded.

Feature Overview

• New options for extended properties available in Column Details when creating or altering a table.

  General Tab Columns

• New extended properties in Constraint Details can be specified for Primary and Foreign keys, Unique and Check constraints when creating a table. Screenshot Constraints Tab

  Constraints Tab

• New options for Storage information, including a description area for explanations of all the parameters. Screenshot Storage Tab

  Storage Tab

• Add meta data for a table in the Comments tab. Screenshot Comments Tab

  Comments Tab

• New options to Add/Revoke permissions for a table and table columns. Screenshot Permissions Tab

  Permissions Tab

• Advanced editing allows you to Insert/Delete columns or constraints from a convenient pop-up menu. Screenshot General Tab

  General Tab