|
Properties |
|
Unique |
Yes |
|
Cluster |
No |
|
Ignore Duplicate Keys |
No |
|
Non-Unique Options |
|
|
Ignore Duplicate Rows |
No |
|
Allow Duplicate Rows |
No |
| Columns |
| NAME | |
| obsno | |
| ics | |
| pcount |
| DDL |
CREATE UNIQUE NONCLUSTERED INDEX ics_extract_pk
ON dbo.ics_extract(obsno,ics,pcount)
go