table icon Table: CreditCard

Properties

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

Extended Properties

Name Value
MS_Description Customer credit card information.

Columns

Column ID Column Name Datatype Nullable Is Sparse Is Column Set
1 CreditCardID int false false false
2 CardType nvarchar(50) false false false
3 CardNumber nvarchar(25) false false false
4 ExpMonth tinyint false false false
5 ExpYear smallint false false false
6 ModifiedDate datetime false false false

Identity Columns

Column Seed Value Increment Value Last Value Is Not For Replication Is Computed Is Sparse Is Column Set
CreditCardID 1 1 19237 false false false false

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_CreditCard_CreditCardID false MS_Description Primary key (clustered) constraint

Primary Key Columns

Name
CreditCardID

Foreign Keys

No foreign keys defined.

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_CreditCard_ModifiedDate ModifiedDate (getdate()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_CreditCard_CreditCardID CLUSTERED true true false false false
AK_CreditCard_CardNumber NONCLUSTERED false true false false false

FullText Indexes

No fulltext indexes defined.

Referencing Tables

Name Key Index ID Is Disabled Is Not For Replication Is Not Trusted Delete Action Update Action Is System Named Referencing Object
FK_PersonCreditCard_CreditCard_CreditCardID 1 false false false No action No action false Sales.PersonCreditCard
FK_SalesOrderHeader_CreditCard_CreditCardID 1 false false false No action No action false Sales.SalesOrderHeader

Object Level Permissions

No object level permissions defined.

Column Level Permissions

No explicit column permissions granted to this object

Statistics

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_CreditCard_CreditCardID Aug 8 2010 5:22PM 19118 19118 4 1 4 false 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

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_CreditCard_CardNumber Aug 8 2010 5:23PM 19118 19118 153 1 32 true 19118

Detailed Statistics Density

All Density Average Length Columns
5.230673E-05 28 CardNumber
5.230673E-05 32 CardNumber, CreditCardID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
11111000471254 0 1 0 1
11111291229899 156 1 156 1
11111382209901 41 1 41 1
11111484309256 63 1 63 1
11111701898504 127 1 127 1
11111869482793 63 1 63 1
11112109575031 127 1 127 1
11112311922686 95 1 95 1
11112783085332 255 1 255 1
11113038110513 127 1 127 1
11113227403806 95 1 95 1
11113575652376 191 1 191 1
11113791367775 95 1 95 1
11113923852420 63 1 63 1
11114180940517 127 1 127 1
11114561419201 191 1 191 1
11114661809849 63 1 63 1
11114906547147 127 1 127 1
11115037059446 63 1 63 1
11115165458471 63 1 63 1
11115274414475 63 1 63 1
11115415484270 63 1 63 1
11115530650617 63 1 63 1
11115711477470 95 1 95 1
11115967595572 127 1 127 1
11116124495122 95 1 95 1
11116318316263 95 1 95 1
11116435706725 63 1 63 1
11116852552248 191 1 191 1
11117113857202 127 1 127 1
11117501304670 191 1 191 1
11117843066700 191 1 191 1
11118040060028 95 1 95 1
11118272686416 127 1 127 1
11118424141184 63 1 63 1
11118591177483 95 1 95 1
11118701618280 63 1 63 1
11118873472846 95 1 95 1
11118983739882 63 1 63 1
11119168029160 95 1 95 1
11119552258369 191 1 191 1
11119669074716 63 1 63 1
11119838751408 95 1 95 1
11119962836659 63 1 63 1
33331081794110 63 1 63 1
33331214548917 63 1 63 1
33331334862680 63 1 63 1
33331544357319 95 1 95 1
33331674907956 63 1 63 1
33331854701856 95 1 95 1
33332039308855 95 1 95 1
33332257046844 127 1 127 1
33332401913805 63 1 63 1
33332498150354 63 1 63 1
33332737574847 127 1 127 1
33332900998173 95 1 95 1
33333007850840 63 1 63 1
33333184961255 95 1 95 1
33333289995217 63 1 63 1
33333618911649 191 1 191 1
33333992841068 191 1 191 1
33334240869967 127 1 127 1
33334503418390 127 1 127 1
33334786119833 127 1 127 1
33334926696786 63 1 63 1
33335168418065 127 1 127 1
33335291396481 63 1 63 1
33335820662575 255 1 255 1
33336061929210 127 1 127 1
33336152796265 63 1 63 1
33336380822678 127 1 127 1
33336500381343 63 1 63 1
33336958026880 255 1 255 1
33337075336312 63 1 63 1
33337296203298 127 1 127 1
33337411860033 63 1 63 1
33337970519730 319 1 319 1
33338210616181 127 1 127 1
33338685417956 255 1 255 1
33338938378790 127 1 127 1
33339161888159 127 1 127 1
33339488603265 191 1 191 1
33339738675737 127 1 127 1
33339959359123 127 1 127 1
55551059602295 63 1 63 1
55551298235978 127 1 127 1
55551526073305 127 1 127 1
55551982785112 255 1 255 1
55552212941772 127 1 127 1
55552791798116 319 1 319 1
55553025611889 127 1 127 1
55553151018961 63 1 63 1
55553396894493 127 1 127 1
55553512901256 63 1 63 1
55553962507588 255 1 255 1
55554105473673 63 1 63 1
55554376851076 127 1 127 1
55554614981506 127 1 127 1
55554980245405 191 1 191 1
55555093945720 63 1 63 1
55555314506046 127 1 127 1
55555490126754 95 1 95 1
55555834713429 191 1 191 1
55555987459258 95 1 95 1
55556159627810 95 1 95 1
55556926736769 383 1 383 1
55557080374180 95 1 95 1
55557267823082 95 1 95 1
55557806813473 287 1 287 1
55557979926852 95 1 95 1
55558139857629 95 1 95 1
55558512147817 191 1 191 1
55558690541111 95 1 95 1
55558854318730 95 1 95 1
55559019080902 95 1 95 1
55559232489308 95 1 95 1
55559814652630 287 1 287 1
77771016679806 95 1 95 1
77771184881669 95 1 95 1
77771423910918 127 1 127 1
77771668806922 127 1 127 1
77771901885639 127 1 127 1
77772148623166 127 1 127 1
77772578201001 255 1 255 1
77772843203296 127 1 127 1
77773080234155 127 1 127 1
77773289974915 127 1 127 1
77773810642656 255 1 255 1
77774037444720 127 1 127 1
77774273011912 127 1 127 1
77774513371337 127 1 127 1
77774778100880 127 1 127 1
77775005818043 127 1 127 1
77775263995834 127 1 127 1
77775517044813 127 1 127 1
77775749464117 127 1 127 1
77776021916364 127 1 127 1
77776242441332 127 1 127 1
77776483278730 127 1 127 1
77776745859885 127 1 127 1
77776974033032 127 1 127 1
77777206634828 127 1 127 1
77777693312252 255 1 255 1
77777909376939 127 1 127 1
77778153469090 127 1 127 1
77778423847175 127 1 127 1
77778667848355 127 1 127 1
77778909891146 127 1 127 1
77779133309174 127 1 127 1
77779377037696 127 1 127 1
77779610084603 127 1 127 1
77779842480754 127 1 127 1
77779999252881 69 1 69 1

Objects that depend on [CreditCard]

Objects on which [CreditCard] depends

SQL

Script
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[CreditCard]( [CreditCardID] [int] IDENTITY(1,1) NOT NULL, [CardType] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CardNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ExpMonth] [tinyint] NOT NULL, [ExpYear] [smallint] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for CreditCard records.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CreditCard', @level2type=N'COLUMN',@level2name=N'CreditCardID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Credit card name.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CreditCard', @level2type=N'COLUMN',@level2name=N'CardType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Credit card number.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CreditCard', @level2type=N'COLUMN',@level2name=N'CardNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Credit card expiration month.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CreditCard', @level2type=N'COLUMN',@level2name=N'ExpMonth'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Credit card expiration year.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CreditCard', @level2type=N'COLUMN',@level2name=N'ExpYear'
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'CreditCard', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer credit card information.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'CreditCard'

See also

List of Tables