Production.Location Table

Information

Name	Location
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
Location	TABLE	MS_Description	Product inventory and manufacturing locations.

Columns

Name	Data Type	Collation	Default
LocationID	smallint
Name	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
CostRate	smallmoney		((0.00))
Availability	decimal(8,2)		((0.00))
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_Location_LocationID	Clustered			LocationID
AK_Location_Name	NonClustered			Name

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_Location_CostRate	CostRate			([CostRate]>=(0.00))
CK_Location_Availability	Availability			([Availability]>=(0.00))

SQL Script

CREATE TABLE [Production].[Location] (
    [LocationID] smallint NOT NULL IDENTITY,
    [Name] nvarchar(50) NOT NULL,
    [CostRate] smallmoney NOT NULL DEFAULT ((0.00)),
    [Availability] decimal(8,2) NOT NULL DEFAULT ((0.00)),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_Location_Name] on [Production].[Location]([Name]);