Sql diagram tool

Free edition: All. Export: CSV. MS Excel. Plain text. SQL script. Go to vendor website. Page options allow you to set the following page settings:. Display print markup displays the print markup grid. Gray stripes show the page overlapping, which can be adjusted. To access the Creating and editing relations option, right-click the line between two entities in the diagram area and perform the following tasks:.

Creating and editing objects. You can create new database objects or edit the existing ones on the diagram area. All the changes you have made to an object on a diagram are permanent and stored on the server.

The Note feature allows you to add comments to the diagram area while designing or analyzing a database structure. You can also add hyperlinks to other resources inside your note. For instance, a hyperlink to wiki pages with database documentation. The Stamp feature displays the information about a database diagram and serves to identify a printed copy of the document. The Adding an arbitrary image to a diagram feature allows you to add additional visual information to the diagram area, such as a diagram sketch, or draft.

Search can also be performed in the stamp company name and project name fields, notes, relation comments, and container names. Notes are yellow boxes with the text you can add to the diagram to explain some diagram parts.

Notes can be moved, brought to front or sent to back, or resized like any other shapes on the diagram. The note allows adding a hyperlink to a file if required. When in SQL Server Management Studio with your database diagram opened and created, right click the link between two tables and go to Properties. I need to know which columns from two tables are in relation, i.

Thanks for the post Ray. It is good to point out that you can modify database schema using the Database Diagram tool. Personally I only use the Database Diagram tool to get a picture of what is there and not to design the database.

I have avoided the diagram feature for years, and discouraged my developers from using it also. Early on we had some bad experiences with folks making unintential and unrecorded changes to data bases.

Related Articles. Getting started with SQL Server database diagrams. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data. How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors.