Table: PersonPhone

Properties

Property	Value
Name	PersonPhone
ID	1653580929
Owner	dbo
Schema	Person
Filegroup	PRIMARY
Data Size (KB)	1184 KB
Index Size (KB)	936 KB
Rows	19972
Unused (KB)	200 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	Telephone number and type of a person.

Columns

Column ID	Column Name	Datatype
1	BusinessEntityID	int
2	PhoneNumber	Phone
3	PhoneNumberTypeID	int
4	ModifiedDate	datetime

Identity Columns

No identity columns defined.

Primary Key Constraints

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

Primary Key Columns

Name
BusinessEntityID
PhoneNumber
PhoneNumberTypeID

Foreign Keys

Name	Referenced Object	Update Action	Delete Action
FK_PersonPhone_Person_BusinessEntityID	Person.Person	No action	No action
FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID	Person.PhoneNumberType	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_PersonPhone_ModifiedDate	ModifiedDate	(getdate())		MS_Description	Default constraint value of GETDATE()

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID	CLUSTERED
IX_PersonPhone_PhoneNumber	NONCLUSTERED

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_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID	Aug 8 2010 5:22PM	19972	19972	9	1	38.43992			19972

Detailed Statistics Density

All Density	Average Length	Columns
5.00701E-05	4	BusinessEntityID
5.00701E-05	34.43992	BusinessEntityID, PhoneNumber
5.00701E-05	38.43992	BusinessEntityID, PhoneNumber, PhoneNumberTypeID

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1	0	1	0	1
264	262	1	262	1
493	127	1	127	1
1581	543	1	543	1
1768	127	1	127	1
1933	95	1	95	1
2028	63	1	63	1
20776	18746	1	18746	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
IX_PersonPhone_PhoneNumber	Aug 8 2010 5:23PM	19972	19972	172	0.7297317	38.43992			19972

Detailed Statistics Density

All Density	Average Length	Columns
0.0001006239	30.43992	PhoneNumber
5.00701E-05	34.43992	PhoneNumber, BusinessEntityID
5.00701E-05	38.43992	PhoneNumber, BusinessEntityID, PhoneNumberTypeID

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1 (11) 500 555-0110	0	135	0	1
1 (11) 500 555-0111	0	180	0	1
1 (11) 500 555-0112	0	185	0	1
1 (11) 500 555-0113	0	192	0	1
1 (11) 500 555-0114	0	186	0	1
1 (11) 500 555-0115	0	187	0	1
1 (11) 500 555-0116	0	192	0	1
1 (11) 500 555-0117	0	182	0	1
1 (11) 500 555-0118	0	209	0	1
1 (11) 500 555-0119	0	182	0	1
1 (11) 500 555-0121	85	86	1	85
1 (11) 500 555-0122	0	98	0	1
1 (11) 500 555-0123	0	82	0	1
1 (11) 500 555-0125	95	100	1	95
1 (11) 500 555-0127	82	91	1	82
1 (11) 500 555-0128	0	76	0	1
1 (11) 500 555-0130	94	85	1	94
1 (11) 500 555-0131	0	102	0	1
1 (11) 500 555-0132	0	93	0	1
1 (11) 500 555-0134	84	84	1	84
1 (11) 500 555-0136	90	87	1	90
1 (11) 500 555-0138	95	84	1	95
1 (11) 500 555-0139	0	98	0	1
1 (11) 500 555-0141	88	74	1	88
1 (11) 500 555-0143	87	96	1	87
1 (11) 500 555-0145	87	104	1	87
1 (11) 500 555-0147	100	101	1	100
1 (11) 500 555-0149	92	95	1	92
1 (11) 500 555-0151	81	96	1	81
1 (11) 500 555-0152	0	84	0	1
1 (11) 500 555-0154	95	95	1	95
1 (11) 500 555-0156	92	91	1	92
1 (11) 500 555-0157	0	100	0	1
1 (11) 500 555-0159	76	99	1	76
1 (11) 500 555-0161	92	109	1	92
1 (11) 500 555-0162	0	103	0	1
1 (11) 500 555-0164	91	103	1	91
1 (11) 500 555-0166	92	80	1	92
1 (11) 500 555-0168	86	90	1	86
1 (11) 500 555-0169	0	108	0	1
1 (11) 500 555-0171	66	84	1	66
1 (11) 500 555-0173	92	93	1	92
1 (11) 500 555-0174	0	109	0	1
1 (11) 500 555-0176	90	99	1	90
1 (11) 500 555-0177	0	109	0	1
1 (11) 500 555-0178	0	98	0	1
1 (11) 500 555-0180	91	109	1	91
1 (11) 500 555-0182	88	110	1	88
1 (11) 500 555-0184	87	93	1	87
1 (11) 500 555-0186	86	90	1	86
1 (11) 500 555-0187	0	98	0	1
1 (11) 500 555-0189	104	104	1	104
1 (11) 500 555-0191	79	109	1	79
1 (11) 500 555-0193	85	101	1	85
1 (11) 500 555-0194	0	97	0	1
1 (11) 500 555-0195	0	83	0	1
1 (11) 500 555-0197	89	85	1	89
1 (11) 500 555-0199	78	73	1	78
107-555-0161	77	2	73	1.054795
111-555-0123	57	2	53	1.075472
113-555-0100	46	5	39	1.179487
116-555-0100	91	6	74	1.22973
117-555-0155	60	2	49	1.22449
120-555-0113	79	3	66	1.19697
125-555-0100	94	4	84	1.119048
129-555-0100	93	5	81	1.148148
131-555-0124	52	3	44	1.181818
133-555-0100	42	4	34	1.235294
136-555-0124	57	3	47	1.212766
139-555-0181	63	3	57	1.105263
142-555-0139	58	3	54	1.074074
145-555-0139	61	2	55	1.109091
148-555-0192	91	2	80	1.1375
151-555-0100	59	2	51	1.156863
157-555-0100	130	2	115	1.130435
159-555-0117	53	3	48	1.104167
161-555-0181	66	2	58	1.137931
164-555-0118	54	3	50	1.08
166-555-0170	57	2	48	1.1875
170-555-0110	49	3	45	1.088889
176-555-0100	135	3	118	1.144068
178-555-0186	55	3	45	1.222222
182-555-0118	59	2	54	1.092593
186-555-0170	88	3	77	1.142857
189-555-0124	52	2	41	1.268293
192-555-0173	63	3	58	1.086207
195-555-0150	62	2	53	1.169811
198-555-0136	52	3	44	1.181818
202-555-0153	58	2	56	1.035714
206-555-0100	40	3	37	1.081081
211-555-0116	63	1	55	1.145455
217-555-0178	63	1	57	1.105263
225-555-0119	63	2	60	1.05
232-555-0155	95	1	83	1.144578
237-555-0198	63	1	61	1.032787
242-555-0183	63	1	55	1.145455
254-555-0148	127	1	124	1.024194
259-555-0181	63	2	58	1.086207
274-555-0100	140	2	135	1.037037
283-555-0130	91	2	89	1.022472
291-555-0169	84	2	81	1.037037
296-555-0171	63	2	57	1.105263
302-555-0121	63	2	56	1.125
312-555-0147	88	2	82	1.073171
318-555-0161	70	2	63	1.111111
324-555-0137	67	2	60	1.116667
331-555-0100	73	2	69	1.057971
337-555-0113	63	2	58	1.086207
341-555-0183	47	2	45	1.044444
350-555-0125	85	2	84	1.011905
358-555-0111	82	2	79	1.037975
371-555-0112	164	2	150	1.093333
377-555-0172	63	2	62	1.016129
390-555-0100	134	2	127	1.055118
397-555-0155	88	2	82	1.073171
406-555-0129	95	2	92	1.032609
411-555-0118	50	3	50	1
416-555-0152	61	2	58	1.051724
422-555-0188	63	1	58	1.086207
428-555-0196	55	2	52	1.057692
433-555-0100	47	4	43	1.093023
438-555-0146	63	1	58	1.086207
444-555-0141	63	2	58	1.086207
449-555-0139	56	2	54	1.037037
454-555-0116	40	2	39	1.025641
459-555-0100	62	2	57	1.087719
464-555-0130	63	1	55	1.145455
469-555-0100	50	2	50	1
481-555-0142	127	1	117	1.08547
488-555-0125	63	1	58	1.086207
493-555-0113	60	3	57	1.052632
498-555-0175	63	1	60	1.05
503-555-0135	63	1	60	1.05
508-555-0156	63	1	58	1.086207
514-555-0138	63	1	60	1.05
520-555-0110	63	1	58	1.086207
532-555-0180	127	1	122	1.040984
538-555-0180	63	1	56	1.125
546-555-0111	84	2	81	1.037037
553-555-0132	71	2	65	1.092308
559-555-0188	71	2	65	1.092308
569-555-0124	94	2	87	1.08046
582-555-0192	146	2	135	1.081481
588-555-0128	63	2	57	1.105263
595-555-0100	72	2	68	1.058824
600-555-0112	62	2	61	1.016393
608-555-0170	95	1	85	1.117647
617-555-0112	95	1	83	1.144578
623-555-0192	95	1	89	1.067416
630-555-0121	68	2	67	1.014925
640-555-0116	95	1	87	1.091954
648-555-0141	95	1	88	1.079545
685-555-0175	384	1	357	1.07563
696-555-0114	95	1	93	1.021505
705-555-0113	95	1	91	1.043956
713-555-0187	95	1	87	1.091954
731-555-0184	191	1	182	1.049451
740-555-0139	95	1	84	1.130952
750-555-0154	94	2	88	1.068182
757-555-0100	73	3	67	1.089552
765-555-0175	95	1	84	1.130952
793-555-0118	287	1	271	1.059041
803-555-0126	95	1	89	1.067416
811-555-0121	95	1	88	1.079545
819-555-0175	95	2	88	1.079545
829-555-0116	95	1	86	1.104651
896-555-0168	671	1	626	1.071885
908-555-0168	95	1	86	1.104651
917-555-0152	95	1	87	1.091954
990-555-0127	768	1	716	1.072626
998-555-0171	95	1	87	1.091954
999-555-0198	9	1	9	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
_WA_Sys_00000003_628FA481	Aug 8 2010 5:23PM	19972	19972	3	0	4			19972

Detailed Statistics Density

All Density	Average Length	Columns
0.3333333	4	PhoneNumberTypeID

Detailed Statistics Histogram

Range High Key	Estimated Rows	Avg Range Rows
1	10096	1
2	9140	1
3	736	1

Objects that depend on [PersonPhone]

Person.PersonPhone

Objects on which [PersonPhone] depends

Person.PersonPhone
- Person.Person
  - Person.AdditionalContactInfoSchemaCollection
  - Person.BusinessEntity
  - Demographics.exist
  - Person.IndividualSurveySchemaCollection
  - dbo.Name
  - dbo.NameStyle
- Person.PhoneNumberType
- dbo.Phone

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Person].[PersonPhone]( [BusinessEntityID] [int] NOT NULL, [PhoneNumber] [dbo].[Phone] NOT NULL, [PhoneNumberTypeID] [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'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Telephone number identification number.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'PhoneNumber' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'PhoneNumberTypeID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Telephone number and type of a person.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone'

Script

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Person].[PersonPhone]( [BusinessEntityID] [int] NOT NULL, [PhoneNumber] [dbo].[Phone] NOT NULL, [PhoneNumberTypeID] [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'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'BusinessEntityID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Telephone number identification number.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'PhoneNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'PhoneNumberTypeID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Telephone number and type of a person.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'PersonPhone'

Table: PersonPhone

Properties

Extended Properties

Columns

Identity Columns

Primary Key Constraints

Primary Key Columns

Foreign Keys

Column Level Check Constraints

Table Level Check Constraints

Default Constraints

Indexes

FullText Indexes

Referencing Tables

Object Level Permissions

Column Level Permissions

Statistics

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [PersonPhone]

Objects on which [PersonPhone] depends

SQL

See also