Skip to content

dbo.sysdiagrams ​

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.sysdiagrams.json and regenerate.

Columns ​

#ColumnTypeNullableFlagsDescription
1namesysnamenoName of the database diagram, as shown in SQL Server Management Studio.
2principal_idintnoDatabase principal (user) ID of the diagram's owner.
3diagram_idintnoidentityPrimary key identifying this database diagram (system-generated SSMS table).
4versionintyesVersion number of the diagram storage format used by SSMS.
5definitionvarbinary(MAX)yesBinary-serialized layout data for the diagram (table positions, connectors) used by SSMS's diagram designer.

Indexes ​

NameTypeUniquePKKey columnsIncludedFilter
PK__sysdiagr__C2B05B613901163BCLUSTEREDyesyesdiagram_id
UK_principal_nameNONCLUSTEREDyesprincipal_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