AdventureWorks

Basic Index   Expanded Index

Table Name:Person.AddressType
Description:Types of addresses stored in the Address table.
Primary Keys:AddressTypeID
FieldTypeDefaultsNulls?Comments
AddressTypeIDint - IdentityNoneNoPrimary key for AddressType records.
Namenvarchar (50)NoneNoAddress type description. For example, Billing, Home, or Shipping.
rowguiduniqueidentifier(newid())NoROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_AddressType_AddressTypeIDYesYesAddressTypeID
AK_AddressType_rowguidNoYesrowguid
AK_AddressType_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_CustomerAddress_AddressType_AddressTypeIDSales.CustomerAddressAddressTypeID
FK_VendorAddress_AddressType_AddressTypeIDPurchasing.VendorAddressAddressTypeID

No triggers