AdventureWorks
PK_EmployeeAddress_EmployeeID_AddressID Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used16.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeyEmployeeIDPrimary key. Foreign key to Employee.EmployeeID.Ascending
Primary KeyAddressIDPrimary key. Foreign key to Address.AddressID.Ascending
Index Statistics
Average key length8.00
Density1.00
Rows in the Table290
Rows Sampled290
Distribution Steps146
UpdatedJan 8 2010 8:41AM
See Also

Related Objects

HumanResources.EmployeeAddress Table
HumanResources Schema
AdventureWorks Database

 

 


© 2012 All Rights Reserved.

Send comments on this topic.