Description
Product model classification.
Table properties
| name | value |
|---|
| name | [Production].[ProductModel] |
| created | Mar 19 2009 9:09PM |
| modified | Mar 19 2009 9:10PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 128 |
| Size of data | 144 kb |
| Size of indexes | 48 kb |
| Maximum size of a single row | 4,294,967,520 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| ProductModelID | int identity(1,1) | 10 | 4 | | no
| yes
| |
| no
| Primary key for ProductModel records.
|
| Name | Name | 50 | 200 | | no
|
| |
| no
| Product model description.
|
| CatalogDescription | xml | max | 2147483646 | | yes
|
| |
| no
| Detailed product catalog information in xml format.
|
| Instructions | xml | max | 2147483646 | | yes
|
| |
| no
| Manufacturing instructions in xml format.
|
| 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 [Production].[ProductModel] depends on
| name | object type | database | server | level |
|---|
| Name | type | AdventureWorks2008 | SPRING\KATMAI | 1 |
Objects that depend on [Production].[ProductModel]
Sample rows
| ProductModelID | Name | CatalogDescription | Instructions | rowguid | ModifiedDate |
|---|
| 1
| Classic Vest
| NULL
| NULL
| 29321d47-1e4c-4aac-887c-19634328c25e
| 6/1/2003 12:00:00 AM
|
| 2
| Cycling Cap
| NULL
| NULL
| 474fb654-3c96-4cb9-82df-2152eeffbdb0
| 6/1/2001 12:00:00 AM
|
| 3
| Full-Finger Gloves
| NULL
| NULL
| a75483fe-3c47-4aa4-93cf-664b51192987
| 6/1/2002 12:00:00 AM
|
| 4
| Half-Finger Gloves
| NULL
| NULL
| 14b56f2a-d4aa-40a4-b9a2-984f165ed702
| 6/1/2002 12:00:00 AM
|
| 5
| HL Mountain Frame
| NULL
| NULL
| fdd5407b-c2db-49d1-a86b-c13a2e3582a2
| 6/1/2001 12:00:00 AM
|
| 6
| HL Road Frame
| NULL
| NULL
| 4d332ecc-48b3-4e04-b7e7-227f3ac2a7ec
| 5/2/1998 12:00:00 AM
|
| 7
| HL Touring Frame
| NULL
| <root xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstruct...
| d60ed2a5-c100-4c54-89a1-531404c4a20f
| 5/16/2005 4:34:28 PM
|
| 8
| LL Mountain Frame
| NULL
| NULL
| 65bf3f6d-bcf2-4db6-8515-fc5c57423037
| 11/20/2002 9:56:38 AM
|
| 9
| LL Road Frame
| NULL
| NULL
| ddc67a2f-024a-4446-9b54-3c679baba708
| 6/1/2001 12:00:00 AM
|
| 10
| LL Touring Frame
| NULL
| <root xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstruct...
| 66c63844-2a24-473c-96d5-d3b3fd57d834
| 5/16/2005 4:34:28 PM
|
Code
CREATE TABLE [Production].[ProductModel](
[ProductModelID] [int] IDENTITY(1,1) NOT NULL,
[Name] [dbo].[Name] NOT NULL,
[ProductModelID] [int] IDENTITY(1,1) NOT NULL,
[CatalogDescription] [xml](CONTENT [Production].[ProductDescriptionSchemaCollection]) NULL,
[Instructions] [xml](CONTENT [Production].[ManuInstructionsSchemaCollection]) NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_ProductModel_ProductModelID] PRIMARY KEY CLUSTERED
(
[ProductModelID] 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].[ProductModel] ADD CONSTRAINT [DF_ProductModel_rowguid] DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Production].[ProductModel] ADD CONSTRAINT [DF_ProductModel_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]