Table: PersonCreditCard Table: PersonCreditCard| 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 |
| Name | Value |
|---|---|
| MS_Description | Cross-reference table mapping people to their credit card information in the CreditCard table. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | BusinessEntityID | int |
|
|
|
| 2 | CreditCardID | int |
|
|
|
| 3 | ModifiedDate | datetime |
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_PersonCreditCard_BusinessEntityID_CreditCardID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| BusinessEntityID |
| CreditCardID |
| 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 |
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_PersonCreditCard_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_PersonCreditCard_BusinessEntityID_CreditCardID | CLUSTERED |
|
|
|
|
|
| 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 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.230673E-05 | 4 | BusinessEntityID |
| 5.230673E-05 | 8 | BusinessEntityID, CreditCardID |
| 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 |
| 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 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.230673E-05 | 4 | CreditCardID |
| 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 |
| 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' |