table icon 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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space PRIMARY
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On true
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
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 false false false
2 zjebka ntext true false false

Identity Columns

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

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK__mobiFT__3213E83F642DD430 true

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 true true false false false

FullText Indexes

Name Corresponding Unique Index Name Is Enabled Change Tracking State Description
FullText Index PK__mobiFT__3213E83F642DD430 true 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK__mobiFT__3213E83F642DD430 false

Detailed Statistics Density

No detailed statistics.

Detailed Statistics Histogram

No histogram statistics.

Objects that depend on [mobiFT]

Objects on which [mobiFT] depends

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