Share via


CreditCard Table (AdventureWorks)

Contains customer credit card information such as the card number and expiration data.

CreditCard Table Definition

The CreditCard table is contained in the Sales schema.

Column

Data type

Nullability

Description

CreditCardID

int

Not null

Primary key for CreditCard rows.

CardType

nvarchar(50)

Not null

Credit card name.

CardNumber

nvarchar(25)

Null

Credit card number.

ExpMonth

tinyint

Null

Credit card expiration month.

ExpYear

smallint

Not null

Credit card expiration year.

ModifiedDate

datetime

Not null

Date and time the row was last updated.