![]() To add a new relationship to the diagram, click the Relationship icon, then click the parent table and then the child table. Relationships can be created between parent and child tables (for other visual references you can use Lines and connect two graphical objects). Views, procedures, functions, sequences, triggers, user defined types and other objectsĪll other supported objects can be added to the diagram either by clicking the Other icon on the main toolbar, selecting the object type and then clicking the diagram area or, by right-clicking the diagram area and selecting the desired object type.Īfter adding the object to the diagram you can double click it and edit properties or use the right side panel for making modifications. Note: Sample data will appear in the diagram if the Sample data mode is activated. Specify new column name, datatype and click Add.ĭetailed column specifics can be defined in a collapsible/expandable area. In section Columns, you can add new table columns. Table propertiesīasic type settings can be specified in the section Details. A new graphical object will appear on the diagram.Īlternatively, you can double click the graphics or right-click the item and choose Edit to open a larger modal form. Add tablesīasic database objects can be added to your project/diagram by clicking the appropriate icon on the main toolbar. To create a new project, click New on the main toolbar and select the SQL Server project type. Quick start guide for SQL Server database design.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |