Manage Schema Object Names Tutorials

Sometimes a Schema can become so large that keeping a handle on all of the names of your objects can become daunting.   That is where the Manage Object Names screen comes in handy.   Here you will find the methods that will allow you to take a step back and work with all of your objects in one place.

  1. Open the Manage Objects Screen:
    There are a number of ways to open the Manage Object Names screen.   Choose the one you are most comfortable with.
    • Click "Schema => Manage => Object Names" from the main menu.
      Object Names
    • Right-Click anywhere in the schema and select "Manage => Object Names".
      Object Names
    • Right-Click anywhere in the Schema Explorer and select "Manage => Object Names".
      Object Names
  2. You can use the Filter to determine which objects are displayed in the list.   All Objects are show by default.
    Filter
  3. There are 4 columns that comprise the list of Objects:
    • The "Custom" column will show the Object's Use Custom Name  status.   The Checkboxes allow you to see and toggle the Custom Name property for the Object.   If the Checkbox is grayed with a 'X' in it, that means the Object does not support the Custom Name property.
      Custom Name
    • The "Full Name" column shows the Objects current name as it will be generated to SQL.   You can click the "Full Name" column header to sort by that column.
      Full Name
    • The "Root Name" column shows the Objects current Root Name.   You can click the "Root Name" column header to sort by that column.
      Root Name
    • The "Type" column shows the Object type (ie.Table, View, Stored Procedure, etc).   You can click the "Type" column header to sort by that column.
      Type
  4. You can toggle an Object's Custom Name property by:
    • Selecting the Object in the list and then pressing the Spacebar.
    • Clicking the Checkbox in the "Custom" column.
    • * If the Checkbox is grayed and contains a 'X', that means that the Object does not support the Custom Name property.
  5. If you want to change an Object's name you can open the Object's Properties screen by:
    • Double Clicking the Object.
    • Selecting the Object and then clicking the Edit button on the right.
      Edit
    • Selecting the Object and then Pressing "Ctrl + E".
  6. Use the "Check/Uncheck All" Checkbox to make all the Objects in the list use or not use Custom Names.
    Check/Uncheck All
    This operation may take a while if there is a large number of Objects in the list.   While the Use Custom Name properties are being set you will see the status as well as a button you can use to cancel the operation.
    Status
  7. Click the OK button to submit your changes.
    - Or -
    Click the Cancel button to discard your changes.