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

title	Set Up Database Diagram Designer
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
f1_keywords	vdt.diagnostic.InstallSqlDiagramSupport
helpviewer_keywords	Database Diagram Designer database diagrams [SQL Server], Database Diagram Designer diagrams [SQL Server], Database Diagram Designer
ms.assetid	927321ee-b459-4f5b-9719-4a7a95639143
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Set Up Database Diagram Designer (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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)