It is possible to arrange the tables automatically according to the dependencies between the tables, zoom the database diagram view in and out, and copy the diagram to the clipboard: Also, we add or remove columns, indexes, and keys, and edit the relations between the tables in that diagram:Īlso, by right-clicking in the white area, we can create a new table in that database or add an existing table to the diagram. In the same way, we remove a table from the diagram. In that window, right-click on any table to change the table view and the content displayed for that table. The database diagram for the selected tables will show the list of columns available in each table and relations between these tables: Choose the tables to include in the database diagram, and click “Add” to proceed:Īrrange these tables in the generated database diagram for a friendlier look. Choose “New Database Diagram” from the menu: At the start, we expand the database and right-click on Database Diagram. SQL Server Management Studio serves excellently to create the Database Diagram.

Using SQL Server Management Studio for Database Diagram creation

It lets you also manage the database schema from the diagram page by creating and modifying database tables, columns, dependencies, indexes, constraints, and keys. It visualizes the database structure and allows you to understand the overall database schema and relations. SQL Server database diagram is a graphical representation of database tables.

Sql server erd tool