Description
Nonclustered index.
Index properties
| name | value |
|---|
| name | [Person].[Address].[IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode]
|
| description | nonclustered, unique located on PRIMARY |
| table | Address
|
| size (kb) | 1728
|
| clustered | False
|
| unique | True
|
| fill factor | 0
|
| filegroup | PRIMARY
|
| ignore duplicate keys | False
|
| index key type | None
|
| disallowPageLocks | False
|
| disallowRowLocks | False
|
| full text key | False
|
| on computed | False
|
| on table | True
|
| system named | False
|
| no automatic recomputation | False
|
| pad index | False
|
| sort in tempdb | False
|
| compact large objects | True
|
| disabled | False
|
| partitioned | False
|
| xml index | False
|
| max degree of parallelism | -1
|
| online index operation | False
|
| parent xml index |
|
| secondary xml index type | None
|
| partition scheme |
|
Columns
| name | sort order | computed | included |
|---|
| AddressLine1
| ascending | False
| False
|
| AddressLine2
| ascending | False
| False
|
| City
| ascending | False
| False
|
| StateProvinceID
| ascending | False
| False
|
| PostalCode
| ascending | False
| False
|
Dependency graph
Objects that [Person].[Address].[IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode] depends on
Code
CREATE UNIQUE NONCLUSTERED INDEX [IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode] ON [Person].[Address]
(
[AddressLine1] ASC,
[AddressLine2] ASC,
[City] ASC,
[StateProvinceID] ASC,
[PostalCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]