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.