# Table: ProductPhoto

## Properties

Property | Value
--- | ---
Name | ProductPhoto
ID | 274100017
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 2240 KB
Index Size (KB) | 16 KB
Rows | 101
Unused (KB) | 80 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space | PRIMARY
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 | 8/8/2010 5:23:40 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Product images.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | ProductPhotoID | int |  |  |
2 | ThumbNailPhoto | varbinary(max) |  |  |
3 | ThumbnailPhotoFileName | nvarchar(50) |  |  |
4 | LargePhoto | varbinary(max) |  |  |
5 | LargePhotoFileName | nvarchar(50) |  |  |
6 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
ProductPhotoID | 1 | 1 | 181 |  |  |  |

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_ProductPhoto_ProductPhotoID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
ProductPhotoID

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_ProductPhoto_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_ProductPhoto_ProductPhotoID | CLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object
--- | --- | --- | --- | --- | --- | --- | --- | ---
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID | 1 |  |  |  | No action | No action |  | Production.ProductProductPhoto

## 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
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_ProductPhoto_ProductPhotoID | Aug 8 2010 5:22PM | 101 | 101 | 54 | 1 | 4 |  |  | 101

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.00990099 | 4 | ProductPhotoID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
69 | 0 | 1 | 0 | 1
70 | 0 | 1 | 0 | 1
72 | 0 | 1 | 0 | 1
73 | 0 | 1 | 0 | 1
76 | 0 | 1 | 0 | 1
78 | 1 | 1 | 1 | 1
80 | 1 | 1 | 1 | 1
82 | 1 | 1 | 1 | 1
84 | 1 | 1 | 1 | 1
86 | 1 | 1 | 1 | 1
88 | 1 | 1 | 1 | 1
90 | 1 | 1 | 1 | 1
91 | 0 | 1 | 0 | 1
95 | 2 | 1 | 2 | 1
99 | 2 | 1 | 2 | 1
100 | 0 | 1 | 0 | 1
102 | 0 | 1 | 0 | 1
103 | 0 | 1 | 0 | 1
107 | 2 | 1 | 2 | 1
109 | 1 | 1 | 1 | 1
111 | 1 | 1 | 1 | 1
113 | 1 | 1 | 1 | 1
115 | 1 | 1 | 1 | 1
119 | 2 | 1 | 2 | 1
120 | 0 | 1 | 0 | 1
123 | 0 | 1 | 0 | 1
125 | 1 | 1 | 1 | 1
127 | 1 | 1 | 1 | 1
129 | 1 | 1 | 1 | 1
131 | 1 | 1 | 1 | 1
135 | 2 | 1 | 2 | 1
137 | 1 | 1 | 1 | 1
139 | 1 | 1 | 1 | 1
141 | 1 | 1 | 1 | 1
143 | 1 | 1 | 1 | 1
145 | 1 | 1 | 1 | 1
147 | 1 | 1 | 1 | 1
151 | 2 | 1 | 2 | 1
153 | 1 | 1 | 1 | 1
155 | 1 | 1 | 1 | 1
157 | 1 | 1 | 1 | 1
159 | 1 | 1 | 1 | 1
161 | 1 | 1 | 1 | 1
163 | 1 | 1 | 1 | 1
165 | 1 | 1 | 1 | 1
167 | 1 | 1 | 1 | 1
169 | 1 | 1 | 1 | 1
170 | 0 | 1 | 0 | 1
174 | 2 | 1 | 2 | 1
176 | 1 | 1 | 1 | 1
178 | 1 | 1 | 1 | 1
180 | 1 | 1 | 1 | 1
181 | 0 | 1 | 0 | 1

## Objects that depend on [ProductPhoto]

- Production.ProductPhoto
  - Production.ProductProductPhoto

## Objects on which [ProductPhoto] depends

- Production.ProductPhoto

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[ProductPhoto]( [ProductPhotoID] [int] IDENTITY(1,1) NOT NULL, [ThumbNailPhoto] [varbinary](max) NULL, [ThumbnailPhotoFileName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LargePhoto] [varbinary](max) NULL, [LargePhotoFileName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for ProductPhoto records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductPhoto', @level2type=N'COLUMN',@level2name=N'ProductPhotoID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Small image of the product.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductPhoto', @level2type=N'COLUMN',@level2name=N'ThumbNailPhoto' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Small image file name.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductPhoto', @level2type=N'COLUMN',@level2name=N'ThumbnailPhotoFileName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Large image of the product.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductPhoto', @level2type=N'COLUMN',@level2name=N'LargePhoto' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Large image file name.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductPhoto', @level2type=N'COLUMN',@level2name=N'LargePhotoFileName' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductPhoto', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product images.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductPhoto'

#### See also

List of Tables