Owner: Sales 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 1496 
Index Size KB: 776 
Rows: 19118 
Description: Customer credit card information. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    CreditCardID  int          Primary key for CreditCard records. 
    CardType  nvarchar  50          Credit card name. 
    CardNumber  nvarchar  25          Credit card number. 
    ExpMonth  tinyint          Credit card expiration month. 
    ExpYear  smallint          Credit card expiration year. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 6 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_CreditCard_CreditCardID      Primary key (clustered) constraint 
  AK_CreditCard_CardNumber      Unique nonclustered index. 
Total: 2 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Sales.SalesOrderHeader  FK_SalesOrderHeader_CreditCard_CreditCardID  PK_CreditCard_CreditCardID 
  Sales.ContactCreditCard  FK_ContactCreditCard_CreditCard_CreditCardID  PK_CreditCard_CreditCardID 
Total: 2 table(s)

Objects that depend on [Sales].[CreditCard]

Object Name Owner Object Type Dep Level
  ContactCreditCard  Sales  Table 
  SalesOrderHeader  Sales  Table 
  vSalesPersonSalesByFiscalYears  Sales  View 
  SalesOrderDetail  Sales  Table 
  SalesOrderHeaderSalesReason  Sales  Table 
  uSalesOrderHeader  Sales  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
Total: 7 object(s)


CREATE TABLE [CreditCard] (
    [CreditCardID] [int] IDENTITY (1, 1) NOT NULL ,
    [CardType] [nvarchar] (50) COLLATE Latin1_General_CS_AS NOT NULL ,
    [CardNumber] [nvarchar] (25) COLLATE Latin1_General_CS_AS NOT NULL ,
    [ExpMonth] [tinyint] NOT NULL ,
    [ExpYear] [smallint] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_CreditCard_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY]

See Also

List of tables