Sales.SalesTerritory Table

Information

Name	SalesTerritory
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:55

Extended Properties

Name	Type	Property Name	Value
SalesTerritory	TABLE	MS_Description	Sales territory lookup table.

Columns

Name	Data Type	Collation	Default
TerritoryID	int
Name	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
CountryRegionCode	nvarchar(3)	SQL_Latin1_General_CP1_CI_AS
Group	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
SalesYTD	money		((0.00))
SalesLastYear	money		((0.00))
CostYTD	money		((0.00))
CostLastYear	money		((0.00))
rowguid	uniqueidentifier		(newid())
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Columns
PK_SalesTerritory_TerritoryID	Clustered	TerritoryID
AK_SalesTerritory_Name	NonClustered	Name
AK_SalesTerritory_rowguid	NonClustered	rowguid

Check Constraints

Name	Column	Expression
CK_SalesTerritory_SalesYTD	SalesYTD	([SalesYTD]>=(0.00))
CK_SalesTerritory_SalesLastYear	SalesLastYear	([SalesLastYear]>=(0.00))
CK_SalesTerritory_CostYTD	CostYTD	([CostYTD]>=(0.00))
CK_SalesTerritory_CostLastYear	CostLastYear	([CostLastYear]>=(0.00))

SQL Script

CREATE TABLE [Sales].[SalesTerritory] (
    [TerritoryID] int NOT NULL IDENTITY,
    [Name] nvarchar(50) NOT NULL,
    [CountryRegionCode] nvarchar(3) NOT NULL,
    [Group] nvarchar(50) NOT NULL,
    [SalesYTD] money NOT NULL DEFAULT ((0.00)),
    [SalesLastYear] money NOT NULL DEFAULT ((0.00)),
    [CostYTD] money NOT NULL DEFAULT ((0.00)),
    [CostLastYear] money NOT NULL DEFAULT ((0.00)),
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_SalesTerritory_Name] on [Sales].[SalesTerritory]([Name]);
CREATE UNIQUE INDEX [AK_SalesTerritory_rowguid] on [Sales].[SalesTerritory]([rowguid]);