# Index: IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode

## Properties

Property | Value
--- | ---
Name | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
ID | 3
Index Type | NONCLUSTERED
Unique |
Filegroup Name | PRIMARY
Ignore Duplicate Key |
Primary Key |
Unique Constraint |
Fill Factor | 0
Padded |
Disabled |
Hypothetical |
Allow Row Locks |
Allow Page Locks |
Has Filter |
Filter Definition |

## Extended Properties

Name | Value
--- | ---
MS_Description | Nonclustered index.

## Index Columns

Column Name | Datatype | Descending Key | Included Column | Key Ordinal | Partition Ordinal
--- | --- | --- | --- | --- | ---
AddressLine1 | nvarchar |  |  | 1 | Not a partitioning column
AddressLine2 | nvarchar |  |  | 2 | Not a partitioning column
City | nvarchar |  |  | 3 | Not a partitioning column
StateProvinceID | int |  |  | 4 | Not a partitioning column
PostalCode | nvarchar |  |  | 5 | Not a partitioning column

#### See also

Table Address
List of Tables