dbo.cam_coords.cam_coords_pk

Object Type	Index
Datasource	IPMA
Database	icsa

Properties

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

Columns

NAME

obsno

count_index

DDL

CREATE UNIQUE NONCLUSTERED INDEX cam_coords_pk
    ON dbo.cam_coords(obsno,count_index)
go