AdventureWorks

Basic Index   Expanded Index

Table Name:Person.ContactType
Description:Lookup table containing the types of contacts stored in Contact.
Primary Keys:ContactTypeID
FieldTypeDefaultsNulls?Comments
ContactTypeIDint - IdentityNoneNoPrimary key for ContactType records.
Namenvarchar (50)NoneNoContact type description.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ContactType_ContactTypeIDYesYesContactTypeID
AK_ContactType_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_StoreContact_ContactType_ContactTypeIDSales.StoreContactContactTypeID
FK_VendorContact_ContactType_ContactTypeIDPurchasing.VendorContactContactTypeID

No triggers