From dbscript Online Help
wikibot
| Table
|
Purchasing.ShipMethod
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| ShipMethodID
|
int
|
not null
|
|
PK_ShipMethod_ShipMethodID
|
|
| Name
|
dbo.Name
|
not null
|
|
|
AK_ShipMethod_Name
|
| ShipBase
|
money
|
not null
|
((0.00))
|
|
|
| ShipRate
|
money
|
not null
|
((0.00))
|
|
|
| rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_ShipMethod_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
wikivalues
| Table Values
|
Purchasing.ShipMethod
|
| ShipMethodID
|
Name
|
ShipBase
|
ShipRate
|
| 1
|
XRQ - TRUCK GROUND
|
3.95
|
0.99
|
| 2
|
ZY - EXPRESS
|
9.95
|
1.99
|
| 3
|
OVERSEAS - DELUXE
|
29.95
|
2.99
|
| 4
|
OVERNIGHT J-FAST
|
21.95
|
1.29
|
| 5
|
CARGO TRANSPORT 5
|
8.99
|
1.49
|
