Sales.SalesReason Table

Information

NameSalesReason
SchemaSales
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:55

Extended Properties

NameTypeProperty NameValue
SalesReasonTABLEMS_DescriptionLookup table of customer purchase reasons.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   SalesReasonIDint   
 
 
 
   Namenvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   ReasonTypenvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_SalesReason_SalesReasonIDClustered  SalesReasonID

SQL Script

CREATE TABLE [Sales].[SalesReason] (
    [SalesReasonID] int NOT NULL IDENTITY,
    [Name] nvarchar(50) NOT NULL,
    [ReasonType] nvarchar(50) NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);