ShipMethod Table (AdventureWorks)

In a lookup table that contains the companies that ship, or delivery.

ShipMethod Table Definition

The ShipMethod table is contained in the Purchasing schema.

Column Data type Nullability Description

ShipMethodID

int

Not null

Primary key.

Name

Name (user-defined type)

nvarchar(50)

Not null

Shipping company name.

ShipBase

money

Not null

Minimum shipping charge.

ShipRate

money

Not null

Shipping charge per pound.

rowguid

uniqueidentifier

Not null

ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

PurchaseOrderDetail Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance