Table: sysdiagrams Table: sysdiagrams| Property | Value |
|---|---|
| Name | sysdiagrams |
| ID | 1527676490 |
| Owner | dbo |
| Schema | dbo |
| Filegroup | PRIMARY |
| Data Size (KB) | 0 KB |
| Index Size (KB) | 0 KB |
| Rows | 0 |
| Unused (KB) | 0 KB |
| ANSI Null On |
|
| Quoted Identifier |
|
| Lock Escalation | TABLE |
| Lock On Bulk Load |
|
| Lob Data Space | PRIMARY |
| Filestream Data Space ID | |
| Has Unchecked Assembly Data |
|
| Text In Row Limit (bytes) | Option not set |
| Large Value Types Out Of Row |
|
| FullText Change Tracking On |
|
| Tracked By Cdc |
|
| Published |
|
| Schema Published |
|
| Replicated |
|
| Replication Filter |
|
| Merge Published |
|
| Sync Tran Subscribed |
|
| MS Shipped |
|
| Modify Date | 6/20/2011 3:16:00 PM |
| Create Date | 6/20/2011 3:15:59 PM |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | name | sysname |
|
|
|
| 2 | principal_id | int |
|
|
|
| 3 | diagram_id | int |
|
|
|
| 4 | version | int |
|
|
|
| 5 | definition | varbinary(max) |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| diagram_id | 1 | 1 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK__sysdiagr__C2B05B615CF6C6BC |
|
| Name |
|---|
| diagram_id |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK__sysdiagr__C2B05B615CF6C6BC | CLUSTERED |
|
|
|
|
|
| UK_principal_name | NONCLUSTERED |
|
|
|
|
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK__sysdiagr__C2B05B615CF6C6BC |
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| UK_principal_name |
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000001_5B0E7E4A |
|
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[sysdiagrams]( [name] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [principal_id] [int] NOT NULL, [diagram_id] [int] IDENTITY(1,1) NOT NULL, [version] [int] NULL, [definition] [varbinary](max) NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'microsoft_database_tools_support', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sysdiagrams' |