V_APPUSER_UNIQUE_CONSTITUENTID

Fields

Field	Field Type	Null	Description
CONSTITUENTID	uniqueidentifier	yes

Indexes

Index Name	Fields	Unique	Primary	Clustered
UIX_V_APPUSER_UNIQUE_CONSTITUENTID	CONSTITUENTID	yes		yes

Definition

Copy


        CREATE VIEW [dbo].[V_APPUSER_UNIQUE_CONSTITUENTID] WITH SCHEMABINDING
        AS
        --Used to enforce unique CONSITUENTID while allowing NULL
        select CONSTITUENTID from dbo.APPUSER where CONSTITUENTID IS NOT NULL;