The Server Model Diagram includes but is not limited to the components above. Tables in the Server Model Diagram Within each table, there are several buttons and property icons that provide details about the table definition. Buttons are the types of properties and associations related to the table and include triggers, indexes, synonyms, primary key, unique keys, check constraints, and foreign keys. Buttons are found just below the name of the table. Property icons , one or more can be found next to the column name, which depicts its properties.
Every column is required to have a datatype and optionality icon.
Other icons for primary key, allowable values, and domain will display if the property is set. After completing the analysis phase and creating your first-cut design, you use the Server Model Diagram to examine the design and refine it. Creating a Server Model Diagram Highlight the database objects in the navigator and then drag them into the workarea. The diagram will automatically display the database objects and their relationships. Modifying a Table Definition Design Editor allows you to change table properties and set additional properties.