How to set properties of other database objects (Enterprise Manager)

To set properties of other database objects

1. Open a database diagram.
2. Right-click the table or relationship line whose properties you want to edit. To edit an index or constraint, select the table that it is attached to.
3. Click Properties.
4. Click the tab that shows the properties for the object you want to edit.
   • Click Tables to rename the table or edit check constraints.
   • Click Relationships to rename the relationship or change the columns that participate in the selected relationship.
   • Click Indexes/Keys to rename an index, create or edit an index or constraint, or set a fill factor.
5. Type or select a new setting.

See Also