| Tables | SQL 2005 Adventure Works OLTP |
Product descriptions in several languages.
Columns
Name Data type Nullable Description ProductDescriptionID int No Column has identity seed value of 1 with a step value of 1.
Primary key for ProductDescription records.Description nvarchar(400) No Description of the product. rowguid uniqueidentifier No Default value: NEWID()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_ProductDescription_rowguid DEFAULT rowguid Value: NEWID()
Default constraint value of NEWID()DF_ProductDescription_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()PK_ProductDescription_ProductDescriptionID PRIMARY KEY ProductDescriptionID Clustered index created by a primary key constraint.
Indices
Name Description AK_ProductDescription_rowguid Unique nonclustered index.Used to support replication samples.
Triggers
Name Description Production.uProductDescription AFTER UPDATE trigger setting the ModifiedDate column in the ProductDescription table to the current date.
Linked tables
Name Description Production.ProductModelProductDescriptionCulture Cross-reference table mapping product descriptions and the language the description is written in.
Accessed by
Name Description Product Catalog Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map. Production.vProductAndDescription Product names and descriptions. Product descriptions are provided in multiple languages.
Modified by
Name Description Production.uProductDescription AFTER UPDATE trigger setting the ModifiedDate column in the ProductDescription table to the current date.
Applies to
Tables | User