V_TEAMFUNDRAISINGTEAM_UNIQUE_TEAMFUNDRAISINGTEAMGROUPID_APPEALID

Fields

Field	Field Type	Null	Description
TEAMFUNDRAISINGTEAMGROUPID	uniqueidentifier	yes
APPEALID	uniqueidentifier

Indexes

Index Name	Fields	Unique	Primary	Clustered
UIX_V_TEAMFUNDRAISINGTEAM_UNIQUE_TEAMFUNDRAISINGTEAMGROUPID_APPEALID	TEAMFUNDRAISINGTEAMGROUPID, APPEALID	yes		yes

Definition

Copy



create view [dbo].[V_TEAMFUNDRAISINGTEAM_UNIQUE_TEAMFUNDRAISINGTEAMGROUPID_APPEALID] with schemabinding
as
    --Used to enforce for each APPEALID a unique TEAMFUNDRAISINGTEAMGROUPID while allowing null values
select TEAMFUNDRAISINGTEAMGROUPID, APPEALID from dbo.TEAMFUNDRAISINGTEAM where TEAMFUNDRAISINGTEAMGROUPID is not null;