If the second table doesn't already contain a column with the same name as the primary key, the modeler adds it to the second table as a foreign key. In the grid, click the column you want to use to uniquely identify each row in the table and select the PK check box to set it as the primary key.įrom the Object Relational or Entity Relationship stencil drag a Relationship shape and drop it onto a blank space on the page.Ĭonnect the higher end to the table with the parent table.Ĭonnect the other end to the child table. In the Database Properties window, under Categories, click Columns. If you reverse engineered the model from an existing database, you may need to drag one or both tables from the Tables and Views window onto the drawing page.ĭouble-click the table you want for the primary key side of the relationship. Make sure both tables are visible in the diagram. Create a relationship in a database model diagram See Can't find the database modeling features? for more information. Note: The Database Model diagram is only available in certain versions of Visio.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |