Modifying Table User Interface Defaults

To modify existing table defaults:

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 modify.

   The Table and Column Properties page displays a report of column defaults.

6. Click the column name you want to modify.

   The Column Defaults page displays.

7. Make modifications and click Apply Changes.

   See Item Help for a description of the individual settings on this page.

   
   

   Note: A column can be removed from the Table Dictionary, thus allowing the Attribute Dictionary defaults to be used during the creation process. For example, when you have auditing columns where you may want the exact same labels and help across every instance of CREATED_BY and CREATED_ON, regardless of which table they come from, you could simply remove the column defaults from each table for those columns.