Person.Address

Field Name Data Type Size Original Type Default Nullable Description Check

AddressID int identity int Not null Primary key for Address records.

AddressLine1 nvarchar 60 Not null First street address line.

AddressLine2 nvarchar 60 Null Second street address line.

City nvarchar 30 Not null Name of the city.

StateProvinceID int Not null Unique identification number for the state or province. Foreign key to StateProvince table.

PostalCode nvarchar 15 Not null Postal code for the street address.

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description
AddressID	int identity		int		Not null	Primary key for Address records.
AddressLine1	nvarchar	60			Not null	First street address line.
AddressLine2	nvarchar	60			Null	Second street address line.
City	nvarchar	30			Not null	Name of the city.
StateProvinceID	int				Not null	Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode	nvarchar	15			Not null	Postal code for the street address.
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Person.Address'

Primary Key Name Field Name

PK_Address_AddressID AddressID

Primary Key Name	Field Name
PK_Address_AddressID	AddressID

Foreign keys for table 'Person.Address', 1 item

Foreign Primary Key Name

Address.StateProvinceID StateProvince.StateProvinceID FK_Address_StateProvince_StateProvinceID

Foreign	Primary	Key Name
Address.StateProvinceID	StateProvince.StateProvinceID	FK_Address_StateProvince_StateProvinceID

Indexes for table 'Person.Address', 4 items

Index Name Description Clustered Unique Fields

PK_Address_AddressID Clustered index created by a primary key constraint. Yes Yes AddressID

AK_Address_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode Nonclustered index. No Yes AddressLine1, AddressLine2, City, StateProvinceID, PostalCode

IX_Address_StateProvinceID Nonclustered index. No No StateProvinceID

Index Name	Description	Clustered	Unique	Fields
PK_Address_AddressID	Clustered index created by a primary key constraint.	Yes	Yes	AddressID
AK_Address_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode	Nonclustered index.	No	Yes	AddressLine1, AddressLine2, City, StateProvinceID, PostalCode
IX_Address_StateProvinceID	Nonclustered index.	No	No	StateProvinceID

Triggers for table 'Person.Address', 1 item

Name Description Type Enabled

uAddress AFTER UPDATE trigger setting the ModifiedDate column in the Address table to the current date. after Update Yes

Name	Description	Type	Enabled
uAddress	AFTER UPDATE trigger setting the ModifiedDate column in the Address table to the current date.	after Update	Yes

Dependencies for table 'Person.Address', 6 items

Object Name Type Field Name

HumanResources.vEmployee view N/A

Person.uAddress trigger N/A

Purchasing.vVendor view N/A

Sales.vIndividualCustomer view N/A

Sales.vSalesPerson view N/A

Sales.vStoreWithDemographics view N/A