Set Up Database Diagram Designer (Visual Database Tools)

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 2005 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

Tasks

Upgrade Database Diagrams from Previous Editions (Visual Database Tools)

Reference

ALTER AUTHORIZATION (Transact-SQL)

Concepts

Understand Database Diagram Ownership (Visual Database Tools)