Table: s

Properties

Property	Value
Name	s
ID	391672443
Owner	dbo
Schema	dbo
Filegroup	PRIMARY
Data Size (KB)	8 KB
Index Size (KB)	8 KB
Rows	2
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	9/20/2010 10:22:06 AM
Create Date	9/20/2010 10:22:06 AM

Extended Properties

Name	Value
MS_Description	mobi update s

Columns

Column ID	Column Name	Datatype
1	id	int
2	name	char(2)
3	cnt	int

Identity Columns

Column	Seed Value	Increment Value	Last Value	Is Not For Replication	Is Computed	Is Sparse	Is Column Set
id	1	1	2

Primary Key Constraints

No primary key constraints defined.

Primary Key Columns

No primary key columns defined.

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

No table indexes defined.

FullText Indexes

No fulltext indexes defined.

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
_WA_Sys_00000001_1758727B	Sep 20 2010 10:26AM	2	2	2	0	4			2

Detailed Statistics Density

All Density	Average Length	Columns
0.5	4	id

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1	0	1	0	1
2	0	1	0	1

Objects that depend on [s]

dbo.s

Objects on which [s] depends

dbo.s

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[s]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnt] [int] NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi update s' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N's'