# 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 |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID | 2
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 | 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 |  |  |
2 | SerialNumber | int |  |  |
3 | Chart | varbinary(max) |  |  |

## 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 |  |  |  |  |
UQ__Records__3214EC0648EFCE0F | NONCLUSTERED |  |  |  |  |

## 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
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
UQ__Records__048A000846136164 |  |  |  |  |  |  |  |  |

### Detailed Statistics Density

No detailed statistics.

### Detailed Statistics Histogram

No histogram statistics.

### Detailed Statistics General

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

### Detailed Statistics Density

No detailed statistics.

### Detailed Statistics Histogram

No histogram statistics.

## Objects that depend on [Records]

- dbo.Records
  - dbo.vw_Records

## Objects on which [Records] depends

- dbo.Records

## 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