table icon Table: Records

Properties

Property Value
Name Records
ID 1143675122
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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID 2
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
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 2/6/2011 5:22:48 PM
Create Date 2/6/2011 5:22:45 PM

Extended Properties

Name Value
MS_Description mobi test comment

Columns

Column ID Column Name Datatype Nullable Is Sparse Is Column Set
1 Id uniqueidentifier false false false
2 SerialNumber int true false false
3 Chart varbinary(max) true false false

Identity Columns

No identity columns defined.

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

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
UQ__Records__048A000846136164 NONCLUSTERED false true true false false
UQ__Records__3214EC0648EFCE0F NONCLUSTERED false true true false false

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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
UQ__Records__048A000846136164 false

Detailed Statistics Density

No detailed statistics.

Detailed Statistics Histogram

No histogram statistics.

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
UQ__Records__3214EC0648EFCE0F false

Detailed Statistics Density

No detailed statistics.

Detailed Statistics Histogram

No histogram statistics.

Objects that depend on [Records]

Objects on which [Records] depends

SQL

Script
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Records]( [Id] [uniqueidentifier] ROWGUIDCOL NOT NULL, [SerialNumber] [int] NULL, [Chart] [varbinary](max) FILESTREAM NULL ) ON [PRIMARY] FILESTREAM_ON [DocumentFileStreamGroup]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'serial no.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Records', @level2type=N'COLUMN',@level2name=N'SerialNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi test comment' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Records'

See also

List of Tables