dbo.pmrfile.pmrfile_ux

Object Type	Index
Datasource	IPMA
Database	controls

Properties

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

Columns

NAME

reqnum

obsno

filename

DDL

CREATE UNIQUE NONCLUSTERED INDEX pmrfile_ux
    ON dbo.pmrfile(reqnum,obsno,filename)
go