Table: t100

Properties

Property	Value
Name	t100
ID	759673754
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	1/18/2011 3:23:22 PM
Create Date	1/18/2011 3:23:22 PM

Extended Properties

Columns

Column ID	Column Name	Datatype	Nullable	Is Sparse	Is Column Set
1	id	int

Identity Columns

Primary Key Constraints

Name	Is System Named	Extended Property Name	Extended Property Value
PK__t100__3213E83F2F2FFC0C

Primary Key Columns

Foreign Keys

Column Level Check Constraints

Table Level Check Constraints

Default Constraints

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
PK__t100__3213E83F2F2FFC0C	CLUSTERED

FullText Indexes

Referencing Tables

Object Level Permissions

Column Level Permissions

Statistics

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
PK__t100__3213E83F2F2FFC0C

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [t100]

• dbo.t100

Objects on which [t100] depends

• dbo.t100

SQL

See also