From dbscript Online Help
wikibot
Table
|
Sales.SpecialOfferProduct
|
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
SpecialOfferID
|
int
|
not null
|
|
PK_SpecialOfferProduct_SpecialOfferID_ProductID
|
|
ProductID
|
int
|
not null
|
|
PK_SpecialOfferProduct_SpecialOfferID_ProductID
|
IX_SpecialOfferProduct_ProductID
|
rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_SpecialOfferProduct_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
automatically generated
Table
|
Sales.SpecialOfferProduct
|
Description
|
Cross-reference table mapping products to special offer discounts.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
PK / Index
|
SpecialOfferID
|
int
|
not null
|
|
Primary key for SpecialOfferProduct records.
|
PK_SpecialOfferProduct_SpecialOfferID_ProductID
|
ProductID
|
int
|
not null
|
|
Product identification number. Foreign key to Product.ProductID.
|
PK_SpecialOfferProduct_SpecialOfferID_ProductIDIX_SpecialOfferProduct_ProductID
|
rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
AK_SpecialOfferProduct_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
|