Properties

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.

Columns

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

Total: 6 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	CreditCardID	1	1

Indexes

	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	1
	SalesOrderHeader	Sales	Table	1
	vSalesPersonSalesByFiscalYears	Sales	View	2
	SalesOrderDetail	Sales	Table	2
	SalesOrderHeaderSalesReason	Sales	Table	2
	uSalesOrderHeader	Sales	Trigger	2
	iduSalesOrderDetail	Sales	Trigger	3

Total: 7 object(s)

SQL

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()),
    CONSTRAINT [PK_CreditCard_CreditCardID] PRIMARY KEY  CLUSTERED
    (
        [CreditCardID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables