Object type: Table

Types of addresses stored in the Address table.

Columns 

Name	Data type	Nullable	Description
AddressTypeID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for AddressType records.
Name	Name	No	Address type description. For example, Billing, Home, or Shipping.
rowguid	uniqueidentifier	No	Default value: NEWID() ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_AddressType_rowguid	DEFAULT	rowguid	Value: NEWID() Default constraint value of NEWID()
DF_AddressType_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_AddressType_AddressTypeID	PRIMARY KEY	AddressTypeID	Clustered index created by a primary key constraint.

Indices 

Name	Description
AK_AddressType_Name	Unique nonclustered index.
AK_AddressType_rowguid	Unique nonclustered index. Used to support replication samples.

Triggers 

Name	Description
Person.uAddressType	AFTER UPDATE trigger setting the ModifiedDate column in the AddressType table to the current date.

Linked tables 

Name	Description
Purchasing.VendorAddress	Cross-reference mapping vendors and addresses.
Sales.CustomerAddress	Cross-reference table mapping customers to their address(es).

Modified by 

Name	Description
Person.uAddressType	AFTER UPDATE trigger setting the ModifiedDate column in the AddressType table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation