dbo.obs_pointing.obs_pointing_ix

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

pointing_id

DDL

CREATE UNIQUE NONCLUSTERED INDEX obs_pointing_ix
    ON dbo.obs_pointing(obsno,pointing_id)
go