AdventureWorks

Basic Index   Expanded Index

Table Name:Purchasing.ShipMethod
Description:Shipping company lookup table.
Primary Keys:ShipMethodID
FieldTypeDefaultsNulls?Comments
ShipMethodIDint - IdentityNoneNoPrimary key for ShipMethod records.
Namenvarchar (50)NoneNoShipping company name.
ShipBasemoney((0.00))NoMinimum shipping charge.
ShipRatemoney((0.00))NoShipping charge per pound.
rowguiduniqueidentifier(newid())NoROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ShipMethod_ShipMethodIDYesYesShipMethodID
AK_ShipMethod_NameNoYesName
AK_ShipMethod_rowguidNoYesrowguid

Check ConstraintText
CK_ShipMethod_ShipBase([ShipBase]>(0.00))
CK_ShipMethod_ShipRate([ShipRate]>(0.00))

No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_PurchaseOrderHeader_ShipMethod_ShipMethodIDPurchasing.PurchaseOrderHeaderShipMethodID
FK_SalesOrderHeader_ShipMethod_ShipMethodIDSales.SalesOrderHeaderShipMethodID

No triggers