Edit

Share via

Set up Database Diagram Designer (Visual Database Tools)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Analytics Platform System (PDW)

To use Database Diagram Designer, it must first be set up by a member of the db_owner role to control access to diagrams.

Set up database diagramming

  1. From Object Explorer, expand a database node.

  2. Expand the Database Diagrams node under the database connection.

  3. Select Yes when prompted if you want to set up database diagramming.

    Note

    This step creates the database diagram table, system stored procedures, and a system function on the SQL Server database.

  4. Visual Studio creates the following objects on the instance of SQL Server:

    • sysdiagrams table
    • sp_alterdiagram stored procedure
    • sp_creatediagram stored procedure
    • sp_dropdiagram stored procedure
    • sp_renamediagram stored procedure
    • fn_diagramobjects function
    • sp_helpdiagrams stored procedure
    • sp_helpdiagramsdefinition stored procedure
    • sp_upgraddiagrams stored procedure

Related content