# Table: mobiFT

## Properties

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

## Extended Properties

No extended properties defined.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | id | int |  |  |
2 | zjebka | ntext |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
id | 1000 | 200 |  |  |  |  |

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK__mobiFT__3213E83F642DD430 |  |  |

## Primary Key Columns

Name
id

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

No default constraints defined.

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK__mobiFT__3213E83F642DD430 | CLUSTERED |  |  |  |  |

## FullText Indexes

Name | Corresponding Unique Index Name | Is Enabled | Change Tracking State Description
--- | --- | --- | ---
FullText Index | PK__mobiFT__3213E83F642DD430 |  | Manual

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK__mobiFT__3213E83F642DD430 |  |  |  |  |  |  |  |  |

### Detailed Statistics Density

No detailed statistics.

### Detailed Statistics Histogram

No histogram statistics.

## Objects that depend on [mobiFT]

- Sales.mobiFT
  - Sales.mobiFTView

## Objects on which [mobiFT] depends

- Sales.mobiFT

## SQL

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]

#### See also

List of Tables