MS SQL Basics Tutorial: Creating and Using charts

A chart is a database object specific to SQL Server that provides users with an intuitive way to manage database tables. Charts allow users to visually create, edit, and edit the relationships between database tables, as well as the properties of tables and their columns.

The steps to create a chart in Enterprise Manager are as follows:

(1) Select "Diagrams" in enterprise Manager, right-click and select the New database Diagram option from the shortcut menu, and the Create Database Diagram Wizard will run, as shown in Figure 8-23. ，

(2) Clicking the Next button, which appears as shown in Figure 8-24, contains the database Table dialog box in the chart, with the Add Related tables automatically option selected, The system automatically adds the tables associated with it to the diagram.

(3) Clicking the Next button shows the end chart creation dialog shown in Figure 8-25, which lists the database tables that will be used to create the chart.