# Table: Location

## Properties

Property | Value
--- | ---
Name | Location
ID | 1365579903
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 8 KB
Index Size (KB) | 24 KB
Rows | 14
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:43 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Product inventory and manufacturing locations.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | LocationID | smallint |  |  |
2 | Name | Name |  |  |
3 | CostRate | smallmoney |  |  |
4 | Availability | decimal(8,2) |  |  |
5 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
LocationID | 1 | 1 | 60 |  |  |  |

## Primary Key Constraints

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

## Primary Key Columns

Name
LocationID

## 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_Location_CostRate | 3 | CostRate | ([CostRate]>=(0.00)) |  |  |  |  |
CK_Location_Availability | 4 | Availability | ([Availability]>=(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_Location_CostRate | CostRate | ((0.00)) |  | MS_Description | Default constraint value of 0.0
DF_Location_Availability | Availability | ((0.00)) |  | MS_Description | Default constraint value of 0.00
DF_Location_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_Location_LocationID | CLUSTERED |  |  |  |  |
AK_Location_Name | 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_ProductInventory_Location_LocationID | 1 |  |  |  | No action | No action |  | Production.ProductInventory
FK_WorkOrderRouting_Location_LocationID | 1 |  |  |  | No action | No action |  | Production.WorkOrderRouting

## 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_Location_LocationID | Aug 8 2010 5:22PM | 14 | 14 | 8 | 1 | 2 |  |  | 14

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.07142857 | 2 | LocationID

### 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
7 | 1 | 1 | 1 | 1
10 | 0 | 1 | 0 | 1
30 | 1 | 1 | 1 | 1
50 | 2 | 1 | 2 | 1
60 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_Location_Name | Aug 8 2010 5:23PM | 14 | 14 | 13 | 1 | 29.71428 |  |  | 14

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.07142857 | 27.71428 | Name
0.07142857 | 29.71428 | Name, LocationID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
Debur and Polish | 0 | 1 | 0 | 1
Final Assembly | 0 | 1 | 0 | 1
Finished Goods Storage | 0 | 1 | 0 | 1
Frame Forming | 0 | 1 | 0 | 1
Frame Welding | 0 | 1 | 0 | 1
Metal Storage | 0 | 1 | 0 | 1
Miscellaneous Storage | 0 | 1 | 0 | 1
Paint | 0 | 1 | 0 | 1
Paint Storage | 1 | 1 | 1 | 1
Sheet Metal Racks | 0 | 1 | 0 | 1
Specialized Paint | 0 | 1 | 0 | 1
Subassembly | 0 | 1 | 0 | 1
Tool Crib | 0 | 1 | 0 | 1

## Objects that depend on [Location]

- Production.Location
  - Production.ProductInventory
    - dbo.ufnGetStock
  - Production.WorkOrderRouting

## Objects on which [Location] depends

- Production.Location
  - dbo.Name

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[Location]( [LocationID] [smallint] IDENTITY(1,1) NOT NULL, [Name] [dbo].[Name] NOT NULL, [CostRate] [smallmoney] NOT NULL, [Availability] [decimal](8, 2) NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for Location records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'LocationID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Location description.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Standard hourly cost of the manufacturing location.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'CostRate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Work capacity (in hours) of the manufacturing location.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'Availability' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product inventory and manufacturing locations.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location'

#### See also

List of Tables