How to: 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. For more information on how diagram ownership works, see Understanding Database Diagram Ownership (Visual Database Tools).

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.


    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

Community Additions