From dbscript Online Help
wikibot
| Table
|
Production.ProductModel
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| ProductModelID
|
int
|
not null
|
|
PK_ProductModel_ProductModelID
|
|
| Name
|
dbo.Name
|
not null
|
|
|
AK_ProductModel_Name
|
| CatalogDescription
|
xml
|
null
|
|
|
PXML_ProductModel_CatalogDescription
|
| Instructions
|
xml
|
null
|
|
|
PXML_ProductModel_Instructions
|
| rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_ProductModel_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
automatically generated
| Table
|
Production.ProductModel
|
| Description
|
Product model classification.
|
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
PK / Index
|
| ProductModelID
|
int
|
not null
|
|
Primary key for ProductModel records.
|
PK_ProductModel_ProductModelID
|
| Name
|
Name
|
not null
|
|
Product model description.
|
AK_ProductModel_Name
|
| CatalogDescription
|
XML
|
null
|
|
Detailed product catalog information in xml format.
|
PXML_ProductModel_CatalogDescription
|
| Instructions
|
XML
|
null
|
|
Manufacturing instructions in xml format.
|
PXML_ProductModel_Instructions
|
| rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
AK_ProductModel_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
|
