dbo.observations.observations_ux

Object Type	Index
Datasource	IPMA
Database	publications

Properties

Unique	Yes
Cluster	No
Ignore Duplicate Keys	Yes
Non-Unique Options
Ignore Duplicate Rows	No
Allow Duplicate Rows	No

Columns

NAME

code

obsno

DDL

CREATE UNIQUE NONCLUSTERED INDEX observations_ux
    ON dbo.observations(code,obsno)
  WITH IGNORE_DUP_KEY
go