Production.ProductPhoto Table

Information

NameProductPhoto
SchemaProduction
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:54

Extended Properties

NameTypeProperty NameValue
ProductPhotoTABLEMS_DescriptionProduct images.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   ProductPhotoIDint   
 
 
 
   ThumbNailPhotovarbinary(max)   
 
 
 
   ThumbnailPhotoFileNamenvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   LargePhotovarbinary(max)   
 
 
 
   LargePhotoFileNamenvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_ProductPhoto_ProductPhotoIDClustered  ProductPhotoID

SQL Script

CREATE TABLE [Production].[ProductPhoto] (
    [ProductPhotoID] int NOT NULL IDENTITY,
    [ThumbNailPhoto] varbinary(max) NULL,
    [ThumbnailPhotoFileName] nvarchar(50) NULL,
    [LargePhoto] varbinary(max) NULL,
    [LargePhotoFileName] nvarchar(50) NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);