Physical Modeling › SQL Server Physical Property Editors

SQL Server Physical Property Editors

You use the SQL Server physical property editors to work with the relational modeling features of SQL Server. These editors are designed with common features that enable you to create and maintain physical modeling objects quickly.

These editors contain the following options:

• Navigation Toolbar
  • Previous

    Positions the editor on the previous object in the navigation grid.

  • Next

    Positions the editor on the next object in the navigation grid.

  • Sort

    Sorts the objects by alphabetic or reverse alphabetic order.

  • DB Sync

    Opens the DB Sync wizard, where you can perform a database-level compare of objects in the current model with matching objects in another model or database.

  • New

    Creates an object that becomes the current object in the editor.

  • Delete

    Deletes the selected object.

  • Help

    Opens online help for the editor.

• Navigation Grid

  Provides a tabular representation of the current object and other objects of the same type. Properties relevant to the object display in separate cells, each with a text entry area, check box, or drop-down control for selecting available values. The amount of space allocated to the Navigation Grid can be adjusted by moving the splitter bar up and down. Columns within the Navigation Grid can be readjusted to be narrower or wider. Once you change a field, when you go to another field, the value is saved. If you click the Cancel button, it only cancels the change of the current field.

• General Tab

  Contains the main options for most SQL Server objects and is where you define most of the necessary properties for that object. In certain editors, some of the options in this tab only become available after you have first selected a check box to enable that option.

• Common Tabs

  Provides additional functionality relevant to the editor. For example, all editors contain a Comment tab that lets you enter comments specific to that object. For objects that must have security features defined, a Permission tab is provided that allows you to define security permissions.

• Undo/Redo/Details

  Provides icons you can click to undo the last action or redo the previous action within the editor. Click the Details button to open the Advisory Message Dialog that displays details about the action.