V_IDMAPPERCATALOG_UNIQUE_PROCEDURENAME

Fields

Field	Field Type	Null	Description
PROCEDURENAME	nvarchar(128)

Indexes

Index Name	Fields	Unique	Primary	Clustered
UIX_V_IDMAPPERCATALOG_UNIQUE_PROCEDURENAME	PROCEDURENAME	yes		yes

Definition

Copy



create view [dbo].[V_IDMAPPERCATALOG_UNIQUE_PROCEDURENAME] with schemabinding
as
--Used to enforce unique PROCEDURENAME while allowing empty values
select PROCEDURENAME from dbo.IDMAPPERCATALOG where PROCEDURENAME <> '';