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.

   [!UWAGA]

   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

Zobacz także

Zadania

Upgrade Database Diagrams from Previous Editions (Visual Database Tools)

Odwołanie

ALTER AUTHORIZATION (Transact-SQL)

Koncepcje

Understand Database Diagram Ownership (Visual Database Tools)