| Property | Value |
|---|---|
| Name | mobiFT |
| ID | 1648724926 |
| Owner | dbo |
| Schema | Sales |
| Filegroup | PRIMARY |
| Data Size (KB) | 0 KB |
| Index Size (KB) | 16 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 | 12/28/2011 5:28:30 PM |
| Create Date | 12/28/2011 5:26:20 PM |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | id | int |
|
|
|
| 2 | zjebka | ntext |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| id | 1000 | 200 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK__mobiFT__3213E83F642DD430 |
|
| Name |
|---|
| id |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK__mobiFT__3213E83F642DD430 | CLUSTERED |
|
|
|
|
|
| Name | Corresponding Unique Index Name | Is Enabled | Change Tracking State Description |
|---|---|---|---|
| FullText Index | PK__mobiFT__3213E83F642DD430 |
|
Manual |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK__mobiFT__3213E83F642DD430 |
|
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[mobiFT]( [id] [int] IDENTITY(1000,200) NOT NULL, [zjebka] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |