Set Up Database Diagram Designer (Visual Database Tools)

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

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

To 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 will create the database diagram table, system stored procedures, and a system function on the SQL Server database.

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

    1. sysdiagrams table

    2. sp_alterdiagram stored procedure

    3. sp_creatediagram stored procedure

    4. sp_dropdiagram stored procedure

    5. sp_renamediagram stored procedure

    6. fn_diagramobjects function

    7. sp_helpdiagrams stored procedure

    8. sp_helpdiagramsdefinition stored procedure

    9. sp_upgraddiagrams stored procedure

See Also

Understand Database Diagram Ownership (Visual Database Tools)
Upgrade Database Diagrams from Previous Editions (Visual Database Tools)
ALTER AUTHORIZATION (Transact-SQL)