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.