Object type: Index

Nonclustered index.

Details 

Table	Unique	Clustered	XML
Person.Address	Yes	No	No

Columns 

Column	Description
AddressLine1	First street address line.
AddressLine2	Second street address line.
City	Name of the city.
StateProvinceID	Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode	Postal code for the street address.

Applies to

Indices | Unique | Non clustered

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