# Table: ShipMethod

## Properties

Property | Value
--- | ---
Name | ShipMethod
ID | 1970106059
Owner | dbo
Schema | Purchasing
Filegroup | PRIMARY
Data Size (KB) | 8 KB
Index Size (KB) | 40 KB
Rows | 5
Unused (KB) | 0 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:41 PM
Create Date | 8/8/2010 5:21:53 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Shipping company lookup table.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | ShipMethodID | int |  |  |
2 | Name | Name |  |  |
3 | ShipBase | money |  |  |
4 | ShipRate | money |  |  |
5 | rowguid | uniqueidentifier |  |  |
6 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
ShipMethodID | 1 | 1 | 5 |  |  |  |

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_ShipMethod_ShipMethodID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
ShipMethodID

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named
--- | --- | --- | --- | --- | --- | --- | --- | ---
CK_ShipMethod_ShipBase | 3 | ShipBase | ([ShipBase]>(0.00)) |  |  |  |  |
CK_ShipMethod_ShipRate | 4 | ShipRate | ([ShipRate]>(0.00)) |  |  |  |  |

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_ShipMethod_ShipBase | ShipBase | ((0.00)) |  | MS_Description | Default constraint value of 0.0
DF_ShipMethod_ShipRate | ShipRate | ((0.00)) |  | MS_Description | Default constraint value of 0.0
DF_ShipMethod_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_ShipMethod_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_ShipMethod_ShipMethodID | CLUSTERED |  |  |  |  |
AK_ShipMethod_Name | NONCLUSTERED |  |  |  |  |
AK_ShipMethod_rowguid | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object
--- | --- | --- | --- | --- | --- | --- | --- | ---
FK_PurchaseOrderHeader_ShipMethod_ShipMethodID | 1 |  |  |  | No action | No action |  | Purchasing.PurchaseOrderHeader
FK_SalesOrderHeader_ShipMethod_ShipMethodID | 1 |  |  |  | No action | No action |  | Sales.SalesOrderHeader

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_ShipMethod_ShipMethodID | Aug 8 2010 5:23PM | 5 | 5 | 3 | 1 | 4 |  |  | 5

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.2 | 4 | ShipMethodID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
3 | 1 | 1 | 1 | 1
5 | 1 | 1 | 1 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_ShipMethod_Name | Aug 8 2010 5:23PM | 5 | 5 | 5 | 0 | 36 |  |  | 5

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.2 | 32 | Name
0.2 | 36 | Name, ShipMethodID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
CARGO TRANSPORT 5 | 0 | 1 | 0 | 1
OVERNIGHT J-FAST | 0 | 1 | 0 | 1
OVERSEAS - DELUXE | 0 | 1 | 0 | 1
XRQ - TRUCK GROUND | 0 | 1 | 0 | 1
ZY - EXPRESS | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_ShipMethod_rowguid | Aug 8 2010 5:23PM | 5 | 5 | 5 | 0 | 20 |  |  | 5

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.2 | 16 | rowguid
0.2 | 20 | rowguid, ShipMethodID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
107e8356-e7a8-463d-b60c-079fff467f3f | 0 | 1 | 0 | 1
3455079b-f773-4dc6-8f1e-2a58649c4ab8 | 0 | 1 | 0 | 1
b166019a-b134-4e76-b957-2b0490c610ed | 0 | 1 | 0 | 1
6be756d9-d7be-4463-8f2c-ae60c710d606 | 0 | 1 | 0 | 1
22f4e461-28cf-4ace-a980-f686cf112ec8 | 0 | 1 | 0 | 1

## Objects that depend on [ShipMethod]

- Purchasing.ShipMethod
  - db_owner.tableSynonym
  - Purchasing.PurchaseOrderHeader
    - Purchasing.PurchaseOrderDetail
      - Purchasing.iPurchaseOrderDetail
      - Purchasing.uPurchaseOrderDetail
    - Purchasing.uPurchaseOrderHeader
  - Sales.SalesOrderHeader
    - Sales.SalesOrderDetail
      - Sales.iduSalesOrderDetail
      - Sales.ufn_SalesByStore
    - Sales.SalesOrderHeaderSalesReason
    - Sales.uSalesOrderHeader
    - Sales.vSalesPersonSalesByFiscalYears

## Objects on which [ShipMethod] depends

- Purchasing.ShipMethod
  - dbo.Name

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Purchasing].[ShipMethod]( [ShipMethodID] [int] IDENTITY(1,1) NOT NULL, [Name] [dbo].[Name] NOT NULL, [ShipBase] [money] NOT NULL, [ShipRate] [money] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for ShipMethod records.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipMethodID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping company name.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Minimum shipping charge.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipBase' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping charge per pound.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipRate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping company lookup table.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod'

#### See also

List of Tables