Table: EmailAddress

Properties

Property	Value
Name	EmailAddress
ID	933578364
Owner	dbo
Schema	Person
Filegroup	PRIMARY
Data Size (KB)	1992 KB
Index Size (KB)	1504 KB
Rows	19972
Unused (KB)	168 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	Where to send a person email.

Columns

Column ID	Column Name	Datatype
1	BusinessEntityID	int
2	EmailAddressID	int
3	EmailAddress	nvarchar(50)
4	rowguid	uniqueidentifier
5	ModifiedDate	datetime

Identity Columns

Column	Seed Value	Increment Value	Last Value	Is Not For Replication	Is Computed	Is Sparse	Is Column Set
EmailAddressID	1	1	19972

Primary Key Constraints

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

Primary Key Columns

Name
BusinessEntityID
EmailAddressID

Foreign Keys

Name	Referenced Object	Update Action	Delete Action
FK_EmailAddress_Person_BusinessEntityID	Person.Person	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_EmailAddress_rowguid	rowguid	(newid())		MS_Description	Default constraint value of NEWID()
DF_EmailAddress_ModifiedDate	ModifiedDate	(getdate())		MS_Description	Default constraint value of GETDATE()

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
PK_EmailAddress_BusinessEntityID_EmailAddressID	CLUSTERED
IX_EmailAddress_EmailAddress	NONCLUSTERED

FullText Indexes

No fulltext indexes defined.

Referencing Tables

No referencing tables defined.

Object Level Permissions

No object level permissions defined.

Column Level Permissions

Permissions for: JohnBlack

EmailAddress

Permission	Grantor	Grant	With Grant	Deny
SELECT
REFERENCES
UPDATE	dbo

Statistics

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
PK_EmailAddress_BusinessEntityID_EmailAddressID	Aug 8 2010 5:22PM	19972	19972	9	1	8			19972

Detailed Statistics Density

All Density	Average Length	Columns
5.00701E-05	4	BusinessEntityID
5.00701E-05	8	BusinessEntityID, EmailAddressID

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_EmailAddress_EmailAddress	Aug 8 2010 5:23PM	19972	19972	196	1	63.16122			19972

Detailed Statistics Density

All Density	Average Length	Columns
5.00701E-05	55.16122	EmailAddress
5.00701E-05	59.16122	EmailAddress, BusinessEntityID
5.00701E-05	63.16122	EmailAddress, BusinessEntityID, EmailAddressID

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
a0@adventure-works.com	0	1	0	1
abigail23@adventure-works.com	94	1	94	1
adam1@adventure-works.com	61	1	61	1
adam48@adventure-works.com	41	1	41	1
adrienne16@adventure-works.com	63	1	63	1
alberto6@adventure-works.com	127	1	127	1
alex19@adventure-works.com	63	1	63	1
alexandra47@adventure-works.com	127	1	127	1
alexandria8@adventure-works.com	95	1	95	1
alisha19@adventure-works.com	127	1	127	1
alma1@adventure-works.com	127	1	127	1
amanda22@adventure-works.com	127	1	127	1
amy23@adventure-works.com	95	1	95	1
andrea13@adventure-works.com	63	1	63	1
andrew10@adventure-works.com	63	1	63	1
angel17@adventure-works.com	63	1	63	1
angelica19@adventure-works.com	95	1	95	1
anna3@adventure-works.com	63	1	63	1
april13@adventure-works.com	127	1	127	1
armando2@adventure-works.com	95	1	95	1
arturo43@adventure-works.com	95	1	95	1
ashley36@adventure-works.com	63	1	63	1
bailey17@adventure-works.com	127	1	127	1
benjamin15@adventure-works.com	127	1	127	1
billiejo0@adventure-works.com	127	1	127	1
blake41@adventure-works.com	63	1	63	1
brad16@adventure-works.com	95	1	95	1
brandy18@adventure-works.com	127	1	127	1
brett21@adventure-works.com	95	1	95	1
brianna39@adventure-works.com	95	1	95	1
brittany10@adventure-works.com	63	1	63	1
bruce35@adventure-works.com	95	1	95	1
byron6@adventure-works.com	95	1	95	1
cameron34@adventure-works.com	127	1	127	1
carl16@adventure-works.com	95	1	95	1
carly13@adventure-works.com	95	1	95	1
carole1@adventure-works.com	63	1	63	1
casey23@adventure-works.com	127	1	127	1
cassie6@adventure-works.com	95	1	95	1
charles16@adventure-works.com	127	1	127	1
chase1@adventure-works.com	63	1	63	1
chloe30@adventure-works.com	95	1	95	1
chris0@adventure-works.com	63	1	63	1
christine13@adventure-works.com	95	1	95	1
christy3@adventure-works.com	63	1	63	1
claudia13@adventure-works.com	95	1	95	1
clinton9@adventure-works.com	95	1	95	1
colleen10@adventure-works.com	95	1	95	1
connor22@adventure-works.com	63	1	63	1
courtney20@adventure-works.com	95	1	95	1
crystal19@adventure-works.com	63	1	63	1
dalton17@adventure-works.com	127	1	127	1
dalton75@adventure-works.com	63	1	63	1
daniel13@adventure-works.com	95	1	95	1
danny22@adventure-works.com	63	1	63	1
dawn12@adventure-works.com	191	1	191	1
deena0@adventure-works.com	127	1	127	1
derek17@adventure-works.com	63	1	63	1
destiny2@adventure-works.com	63	1	63	1
devin73@adventure-works.com	127	1	127	1
dominic16@adventure-works.com	95	1	95	1
donald7@adventure-works.com	63	1	63	1
dustin16@adventure-works.com	95	1	95	1
dylan34@adventure-works.com	63	1	63	1
edgar1@adventure-works.com	95	1	95	1
eduardo75@adventure-works.com	95	1	95	1
edward51@adventure-works.com	63	1	63	1
edwin44@adventure-works.com	63	1	63	1
elizabeth13@adventure-works.com	63	1	63	1
emma34@adventure-works.com	127	1	127	1
erica12@adventure-works.com	127	1	127	1
erika1@adventure-works.com	63	1	63	1
ernest5@adventure-works.com	63	1	63	1
eugene11@adventure-works.com	63	1	63	1
faith35@adventure-works.com	127	1	127	1
fernando39@adventure-works.com	63	1	63	1
franklin11@adventure-works.com	127	1	127	1
gabriella18@adventure-works.com	127	1	127	1
garrett24@adventure-works.com	127	1	127	1
gavin8@adventure-works.com	63	1	63	1
glenn8@adventure-works.com	191	1	191	1
greg2@adventure-works.com	127	1	127	1
hailey27@adventure-works.com	63	1	63	1
haley27@adventure-works.com	63	1	63	1
hannah30@adventure-works.com	63	1	63	1
henry12@adventure-works.com	127	1	127	1
hunter24@adventure-works.com	63	1	63	1
ian77@adventure-works.com	127	1	127	1
isaac5@adventure-works.com	63	1	63	1
isabelle17@adventure-works.com	127	1	127	1
jack53@adventure-works.com	127	1	127	1
jacob9@adventure-works.com	127	1	127	1
jacquelyn23@adventure-works.com	63	1	63	1
jaime15@adventure-works.com	63	1	63	1
janet10@adventure-works.com	255	1	255	1
jasmine44@adventure-works.com	127	1	127	1
jason46@adventure-works.com	63	1	63	1
jenna0@adventure-works.com	127	1	127	1
jenny16@adventure-works.com	127	1	127	1
jeremiah32@adventure-works.com	63	1	63	1
jerry5@adventure-works.com	127	1	127	1
jessie11@adventure-works.com	127	1	127	1
jill0@adventure-works.com	63	1	63	1
joanna13@adventure-works.com	127	1	127	1
joe1@adventure-works.com	63	1	63	1
johnathan12@adventure-works.com	127	1	127	1
jonathan42@adventure-works.com	127	1	127	1
jordan72@adventure-works.com	127	1	127	1
jose18@adventure-works.com	63	1	63	1
joshua25@adventure-works.com	127	1	127	1
juan6@adventure-works.com	63	1	63	1
julia48@adventure-works.com	63	1	63	1
julian5@adventure-works.com	63	1	63	1
justin16@adventure-works.com	63	1	63	1
kaitlin6@adventure-works.com	63	1	63	1
kaitlyn63@adventure-works.com	63	1	63	1
kari5@adventure-works.com	127	1	127	1
kate18@adventure-works.com	63	1	63	1
katherine14@adventure-works.com	63	1	63	1
katherine72@adventure-works.com	63	1	63	1
kayla12@adventure-works.com	127	1	127	1
kaylee27@adventure-works.com	63	1	63	1
kelly16@adventure-works.com	127	1	127	1
kelvin30@adventure-works.com	63	1	63	1
kevin57@adventure-works.com	127	1	127	1
kristi10@adventure-works.com	95	1	95	1
kristine21@adventure-works.com	95	1	95	1
kurt9@adventure-works.com	95	1	95	1
lacey8@adventure-works.com	95	1	95	1
latoya8@adventure-works.com	95	1	95	1
lauren7@adventure-works.com	95	1	95	1
leslie0@adventure-works.com	95	1	95	1
lindsay2@adventure-works.com	95	1	95	1
logan37@adventure-works.com	95	1	95	1
louis3@adventure-works.com	95	1	95	1
lucas72@adventure-works.com	95	1	95	1
luke23@adventure-works.com	95	1	95	1
mackenzie39@adventure-works.com	95	1	95	1
makayla14@adventure-works.com	95	1	95	1
marc18@adventure-works.com	95	1	95	1
marcus59@adventure-works.com	95	1	95	1
maria29@adventure-works.com	95	1	95	1
marie14@adventure-works.com	95	1	95	1
marshall10@adventure-works.com	95	1	95	1
marvin15@adventure-works.com	95	1	95	1
mason40@adventure-works.com	95	1	95	1
max20@adventure-works.com	95	1	95	1
megan50@adventure-works.com	95	1	95	1
melinda10@adventure-works.com	95	1	95	1
melvin3@adventure-works.com	95	1	95	1
michael24@adventure-works.com	95	1	95	1
michele44@adventure-works.com	95	1	95	1
mikael0@adventure-works.com	127	1	127	1
molly2@adventure-works.com	127	1	127	1
morgan80@adventure-works.com	127	1	127	1
natalie49@adventure-works.com	127	1	127	1
nathan6@adventure-works.com	127	1	127	1
nichole6@adventure-works.com	127	1	127	1
noah1@adventure-works.com	127	1	127	1
olivia50@adventure-works.com	127	1	127	1
paige2@adventure-works.com	127	1	127	1
paula0@adventure-works.com	127	1	127	1
philip8@adventure-works.com	127	1	127	1
rachel33@adventure-works.com	127	1	127	1
randall12@adventure-works.com	127	1	127	1
rebekah0@adventure-works.com	127	1	127	1
ricardo21@adventure-works.com	127	1	127	1
ricky4@adventure-works.com	127	1	127	1
robert77@adventure-works.com	127	1	127	1
roger41@adventure-works.com	127	1	127	1
ross8@adventure-works.com	127	1	127	1
ruth15@adventure-works.com	127	1	127	1
samantha29@adventure-works.com	127	1	127	1
sandra6@adventure-works.com	127	1	127	1
savannah32@adventure-works.com	127	1	127	1
sergio21@adventure-works.com	127	1	127	1
shannon1@adventure-works.com	127	1	127	1
shawna19@adventure-works.com	127	1	127	1
sophia15@adventure-works.com	127	1	127	1
stefanie2@adventure-works.com	127	1	127	1
steven24@adventure-works.com	127	1	127	1
sydney22@adventure-works.com	127	1	127	1
tamara0@adventure-works.com	127	1	127	1
tasha7@adventure-works.com	127	1	127	1
terrence16@adventure-works.com	127	1	127	1
thomas46@adventure-works.com	127	1	127	1
tina17@adventure-works.com	127	1	127	1
tonya21@adventure-works.com	127	1	127	1
troy14@adventure-works.com	127	1	127	1
veronica13@adventure-works.com	127	1	127	1
vincent3@adventure-works.com	127	1	127	1
wendy0@adventure-works.com	127	1	127	1
willie39@adventure-works.com	127	1	127	1
xavier50@adventure-works.com	127	1	127	1
zachary8@adventure-works.com	127	1	127	1
zoe9@adventure-works.com	27	1	27	1

Objects that depend on [EmailAddress]

Person.EmailAddress

Objects on which [EmailAddress] depends

Person.EmailAddress
- Person.Person
  - Person.AdditionalContactInfoSchemaCollection
  - Person.BusinessEntity
  - Demographics.exist
  - Person.IndividualSurveySchemaCollection
  - dbo.Name
  - dbo.NameStyle

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Person].[EmailAddress]( [BusinessEntityID] [int] NOT NULL, [EmailAddressID] [int] IDENTITY(1,1) NOT NULL, [EmailAddress] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. ID of this email address.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'EmailAddressID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'E-mail address for the person.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'EmailAddress' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'rowguid' 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'EmailAddress', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Where to send a person email.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress'

Script

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Person].[EmailAddress]( [BusinessEntityID] [int] NOT NULL, [EmailAddressID] [int] IDENTITY(1,1) NOT NULL, [EmailAddress] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'BusinessEntityID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. ID of this email address.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'EmailAddressID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'E-mail address for the person.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'EmailAddress'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress', @level2type=N'COLUMN',@level2name=N'rowguid'
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'EmailAddress', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Where to send a person email.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'EmailAddress'

Table: EmailAddress

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

Permissions for: JohnBlack

EmailAddress

Statistics

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [EmailAddress]

Objects on which [EmailAddress] depends

SQL

See also