set-up-database-diagram-designer-visual-database-tools.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords
Set Up Database Diagram Designer	Set Up Database Diagram Designer (Visual Database Tools)	markingmyname	maghan	01/19/2017	sql	ssms	conceptual	vdt.diagnostic.InstallSqlDiagramSupport	Database Diagram Designer database diagrams [SQL Server], Database Diagram Designer diagrams [SQL Server], Database Diagram Designer

Set Up Database Diagram Designer (Visual Database Tools)

[!INCLUDESQL Server Azure SQL Database 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.

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 [!INCLUDEssNoVersion] database.

4. Visual Studio will create the following objects on the instance of [!INCLUDEssNoVersion]:

   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)