table icon 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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
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 false false false
2 Name Name false false false
3 CostRate smallmoney false false false
4 Availability decimal(8,2) false false false
5 ModifiedDate datetime false false false

Identity Columns

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

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_Location_LocationID false 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)) false false false true false
CK_Location_Availability 4 Availability ([Availability]>=(0.00)) false false false true false

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)) false MS_Description Default constraint value of 0.0
DF_Location_Availability Availability ((0.00)) false MS_Description Default constraint value of 0.00
DF_Location_ModifiedDate ModifiedDate (getdate()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_Location_LocationID CLUSTERED true true false false false
AK_Location_Name NONCLUSTERED false true false false false

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 false false false No action No action false Production.ProductInventory
FK_WorkOrderRouting_Location_LocationID 1 false false false No action No action false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_Location_LocationID Aug 8 2010 5:22PM 14 14 8 1 2 false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_Location_Name Aug 8 2010 5:23PM 14 14 13 1 29.71428 true 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]

Objects on which [Location] depends

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