ShipMethod Table (AdventureWorks)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

ShipMethod Table (AdventureWorks)

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

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.

Show:
© 2016 Microsoft