Sales.CreditCard Table

Information

NameCreditCard
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
CreditCardTABLEMS_DescriptionCustomer credit card information.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   CreditCardIDint   
 
 
 
   CardTypenvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   CardNumbernvarchar(25) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   ExpMonthtinyint   
 
 
 
   ExpYearsmallint   
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_CreditCard_CreditCardIDClustered  CreditCardID
AK_CreditCard_CardNumberNonClustered  CardNumber

SQL Script

CREATE TABLE [Sales].[CreditCard] (
    [CreditCardID] int NOT NULL IDENTITY,
    [CardType] nvarchar(50) NOT NULL,
    [CardNumber] nvarchar(25) NOT NULL,
    [ExpMonth] tinyint NOT NULL,
    [ExpYear] smallint NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_CreditCard_CardNumber] on [Sales].[CreditCard]([CardNumber]);