| Property | Value |
|---|---|
| Name | t10 |
| ID | 1351675863 |
| 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 | |
| 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 | 5/7/2011 1:22:51 AM |
| Create Date | 5/7/2011 1:20:38 AM |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | c1 | int |
|
|
|
| 2 | c2 | int |
|
|
|
| 3 | c3 | int |
|
|
|
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| t10_c2_idx | NONCLUSTERED |
|
|
|
|
|
| t10_c3_uq | NONCLUSTERED |
|
|
|
|
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| t10_c2_idx |
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| t10_c3_uq |
|
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[t10]( [c1] [int] NULL, [c2] [int] NULL, [c3] [int] NULL ) ON [PRIMARY] |