Appearance
dbo.sysdiagrams
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.sysdiagrams.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | name | sysname | no | Name of the database diagram, as shown in SQL Server Management Studio. | |
| 2 | principal_id | int | no | Database principal (user) ID of the diagram's owner. | |
| 3 | diagram_id | int | no | identity | Primary key identifying this database diagram (system-generated SSMS table). |
| 4 | version | int | yes | Version number of the diagram storage format used by SSMS. | |
| 5 | definition | varbinary(MAX) | yes | Binary-serialized layout data for the diagram (table positions, connectors) used by SSMS's diagram designer. |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK__sysdiagr__C2B05B613901163B | CLUSTERED | yes | yes | diagram_id | ||
| UK_principal_name | NONCLUSTERED | yes | principal_id, name |
Referenced by
Procedures: dbo.sp_alterdiagram, dbo.sp_creatediagram, dbo.sp_dropdiagram, dbo.sp_helpdiagramdefinition, dbo.sp_helpdiagrams, dbo.sp_renamediagram, dbo.sp_upgraddiagrams

