Production.ProductDescription Table

Description

Product descriptions in several languages.

Properties

Creation Date	27/10/2017 14:33
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	762
Data Space Used	144.00 KB
Index Space Used	56.00 KB

Columns

Column Name	Description	Datatype	Length	Default
ProductDescriptionID	Primary key for ProductDescription records.	Integer	4
Description	Description of the product.	VarWChar	400
rowguid	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	GUID	16	(newid())
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_ProductDescription_rowguid	Unique nonclustered index. Used to support replication samples.
PK_ProductDescription_ProductDescriptionID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID	Foreign key constraint referencing ProductDescription.ProductDescriptionID.

Objects that depend on Production.ProductDescription

	Database Object	Object Type	Description	Dep Level
	Production.ProductModelProductDescriptionCulture	Table	Cross-reference table mapping product descriptions and the language the description is written in.	1
	Production.vProductAndDescription	View	Product names and descriptions. Product descriptions are provided in multiple languages.	1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[ProductDescription](
    [ProductDescriptionID] [int] IDENTITY(1,1) NOT NULL,
    [Description] [nvarchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ProductDescription_ProductDescriptionID] PRIMARY KEY CLUSTERED 
(
    [ProductDescriptionID] 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].[ProductDescription] ADD  CONSTRAINT [DF_ProductDescription_rowguid]  DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Production].[ProductDescription] ADD  CONSTRAINT [DF_ProductDescription_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects