# Table: PersonCreditCard

## Properties

Property | Value
--- | ---
Name | PersonCreditCard
ID | 1621580815
Owner | dbo
Schema | Sales
Filegroup | PRIMARY
Data Size (KB) | 480 KB
Index Size (KB) | 16 KB
Rows | 19118
Unused (KB) | 88 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:39 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Cross-reference table mapping people to their credit card information in the CreditCard table.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | BusinessEntityID | int |  |  |
2 | CreditCardID | int |  |  |
3 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_PersonCreditCard_BusinessEntityID_CreditCardID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
BusinessEntityID
CreditCardID

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_PersonCreditCard_Person_BusinessEntityID | Person.Person | No action | No action
FK_PersonCreditCard_CreditCard_CreditCardID | Sales.CreditCard | No action | No action

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_PersonCreditCard_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_PersonCreditCard_BusinessEntityID_CreditCardID | CLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_PersonCreditCard_BusinessEntityID_CreditCardID | Aug 8 2010 5:22PM | 19118 | 19118 | 7 | 1 | 8 |  |  | 19118

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
5.230673E-05 | 4 | BusinessEntityID
5.230673E-05 | 8 | BusinessEntityID, CreditCardID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
293 | 0 | 1 | 0 | 1
1299 | 454 | 1 | 454 | 1
1739 | 127 | 1 | 127 | 1
1903 | 95 | 1 | 95 | 1
2403 | 63 | 1 | 63 | 1
20776 | 18372 | 1 | 18372 | 1
20777 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000002_60A75C0F | Aug 8 2010 5:23PM | 19118 | 19118 | 4 | 1 | 4 |  |  | 19118

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
5.230673E-05 | 4 | CreditCardID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
16493 | 16486 | 1 | 16486 | 1
19236 | 2628 | 1 | 2628 | 1
19237 | 0 | 1 | 0 | 1

## Objects that depend on [PersonCreditCard]

- Sales.PersonCreditCard

## Objects on which [PersonCreditCard] depends

- Sales.PersonCreditCard
  - Person.Person
    - Person.AdditionalContactInfoSchemaCollection
    - Person.BusinessEntity
    - Demographics.exist
    - Person.IndividualSurveySchemaCollection
    - dbo.Name
    - dbo.NameStyle
  - Sales.CreditCard

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[PersonCreditCard]( [BusinessEntityID] [int] NOT NULL, [CreditCardID] [int] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business entity identification number. Foreign key to Person.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'PersonCreditCard', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Credit card identification number. Foreign key to CreditCard.CreditCardID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'PersonCreditCard', @level2type=N'COLUMN',@level2name=N'CreditCardID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'PersonCreditCard', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference table mapping people to their credit card information in the CreditCard table. ' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'PersonCreditCard'

#### See also

List of Tables