Editing Schema Properties

Whether you are creating a new Schema document or working with an existing document, there are many options available to adjust the behavior of the document and the environment in which it is manipulated.   Here you will find a description of the properties available through Database Schema Designer.

1. Open the Schema Properties Screen

   When creating a new Schema:

   Click "File -> New" from the menu.

   

   When altering an existing opened Schema:

   Click "Schema -> Properties" from the menu.

   
2. Setup the Schema options:
   1. Properties Tab
      

      This tab is used to setup the basic properties of the Schema.  Here you can:

      • Set the name of the Schema.
      • Give the Schema a Description.
      • Set the author of the Schema.
      • Adjust the created and modified dates of the Schema.
      • Choose the Naming Convention  to use with the Schema.
      • Set the version of this Schema.
   2. Page Setup Tab
      

      This tab is used to setup the properties of the Schemas pages.  Here you can:

      • Choose the number of pages to create for the Schema and how many rows and columns there will be.
      • Choose the size of the paper to use for the Schema.
      • Set the size of the margin to use for the Schema.
      • Choose the paper orientation.
      • Toggle the display of page lines in the Schema.
      • Toggle the display of page numbers in the Schema
      • Toggle the display of a Header and Footer when printing the Schema.
      • Define a custom Header and Footer for the printed Schema.
      • Reset the values on this tab to their Application Defaults.
   3. Page Setup Tab
      

      This tab is used to setup the display properties of the Schemas visible objects.  Here you can:

      • Choose the font face, size and color to use when rendering Comments, Tables, and Views.
      • Choose the background color to use when rendering Comments, Foreign Keys, Tables and Views.
      • Toggle the display of the object icons when rendering Comments, Tables, and Views.
      • Toggle the display of Table column Datatypes, Nullability and Unique Constraints.
      • Reset the values on this tab to their Application Defaults.
   4. Settings Tab
      

      This tab is used to setup the advanced application settings of the Schema.  Here you can:

      • Set the number of Undo/Redo points that will be tracked for the Schema.
      • Determine whether non-critical application warnings will be displayed while using the Schema.
      • Determine whether newly created objects will Use Custom Names  or application assisted names.
      • Toggle the creation of a Primary Key Column on newly created Tables.
      • Determine if the auto-created Primary Key Column is also an Identity Column.
      • Toggle the creation of a string (VarChar) column for newly created Tables.
      • Toggle the use of the Primary Key Prefix  system on new Tables.
      • Determine if a Table's Foreign Key Constraints recaculate their position when a Table is moved.
      • Reset the values on this tab to their Application Defaults.
3. Click the OK button to submit your settings.
   - Or -
   Click the Cancel button to discard your settings.