Creating User Interface Defaults for a Table

If no defaults have been created for a table, use the Table Dictionary Create Defaults wizard to automatically generate defaults based on the database table and column definitions. After the initial defaults are created, you can modify the individual default values. See "Modifying Table User Interface Defaults".

To create the initial user interface defaults for tables:

1. On the Workspace home page, click the SQL Workshop.

2. Click Utilities.

3. Click User Interface Defaults.

   The Dashboard page for User Interface Defaults appears.

   The current schema displays to the right of the breadcrumb menu.

4. Click Manage Table Dictionary.

   The Table Dictionary page displays a report of all objects in your workspace that includes a Defaults Exist column indicating whether or not defaults have been created for each object.

5. Click the object name you want to create defaults for.

   The Create Table Dictionary Defaults page appears.

6. Click Create Defaults.

   The Table Dictionary page displays a report showing that defaults exist for the object you selected.

   
   

   Note: Synchronizing defaults with the database data dictionary creates table based defaults for any tables in the current schema that do not have defaults yet and adjusts those of tables that do to match the database definition.