Description
Product descriptions in several languages.
Table properties
| name | value |
|---|
| name | [Production].[ProductDescription] |
| created | Mar 19 2009 9:08PM |
| modified | Mar 19 2009 9:08PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 762 |
| Size of data | 144 kb |
| Size of indexes | 56 kb |
| Maximum size of a single row | 1,628 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| ProductDescriptionID | int identity(1,1) | 10 | 4 | | no
| yes
| |
| no
| Primary key for ProductDescription records.
|
| Description | nvarchar(400) | 400 | 1600 | | no
|
| |
| no
| Description of the product.
|
| rowguid | uniqueidentifier | 36 | 16 | (newid()) | no
|
| |
| no
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
Referenced by
Foreign key graph
Defaults
Dependency graph
Objects that depend on [Production].[ProductDescription]
Sample rows
| ProductDescriptionID | Description | rowguid | ModifiedDate |
|---|
| 3
| Chromoly steel.
| 301eed3a-1a82-4855-99cb-2afe8290d641
| 6/1/2003 12:00:00 AM
|
| 4
| Aluminum alloy cups; large diameter spindle.
| dfeba528-da11-4650-9d86-cafda7294eb0
| 6/1/2003 12:00:00 AM
|
| 5
| Aluminum alloy cups and a hollow axle.
| f7178da7-1a7e-4997-8470-06737181305e
| 6/1/2003 12:00:00 AM
|
| 8
| Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable...
| 8e6746e5-ad97-46e2-bd24-fcea075c3b52
| 6/1/2003 12:00:00 AM
|
| 64
| This bike delivers a high-level of performance on a budget. It is responsive and maneuverable, and o...
| 7b1c4e90-85e2-4792-b47b-e0c424e2ec94
| 6/1/2003 12:00:00 AM
|
| 88
| For true trail addicts. An extremely durable bike that will go anywhere and keep you in control on ...
| 4c1ad253-357e-4a98-b02e-02180aa406f6
| 6/1/2003 12:00:00 AM
|
| 128
| Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mo...
| 130709e6-8512-49b9-9f62-1f5c99152056
| 3/11/2004 10:32:17 AM
|
| 168
| Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL F...
| db979da6-4cc8-4171-9ecf-65003ff8178a
| 6/1/2003 12:00:00 AM
|
| 170
| Suitable for any type of off-road trip. Fits any budget.
| ea772412-6369-4416-9cc9-c1a5d1ff9c52
| 6/1/2003 12:00:00 AM
|
| 209
| Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hub...
| f5ff5ffd-cb7c-4ad6-bbc9-4d250bb6e98d
| 6/1/2003 12:00:00 AM
|
Code
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,
[ProductDescriptionID] [int] IDENTITY(1,1) NOT NULL,
[Description] [nvarchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS 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]