Description
Properties
Creation Date | 08/01/2010 08:40 |
File Group | PRIMARY |
Text File Group | PRIMARY |
System Object |  |
Published for Replication |  |
Rows | 101 |
Data Space Used | 2,240.00 KB |
Index Space Used | 16.00 KB |
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula |
| ProductPhotoID | Primary key for ProductPhoto records. | int | 4 | | | |
| ThumbNailPhoto | Small image of the product. | varbinary | 16 |  | | |
| ThumbnailPhotoFileName | Small image file name. | nvarchar | 50 |  | | |
| LargePhoto | Large image of the product. | varbinary | 16 |  | | |
| LargePhotoFileName | Large image file name. | nvarchar | 50 |  | | |
| ModifiedDate | Date and time the record was last updated. | datetime | 4 | | (getdate()) | |
Indexes
Relationships
Objects that depend on Production.ProductPhoto
SQL
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,
CONSTRAINT [PK_ProductPhoto_ProductPhotoID] PRIMARY KEY CLUSTERED
(
[ProductPhotoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [Production].[ProductPhoto] ADD CONSTRAINT [DF_ProductPhoto_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
|
See Also