V_EXPORTPROCESS_UNIQUE_NAME

Used to enforce unique values on the EXPORTPROCESS.NAME field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the EXPORTPROCESS table.

Fields

Field Field Type Null Description
NAME nvarchar(255) Name of the export process.

Indexes

Index Name Fields Unique Primary Clustered
UIX_V_EXPORTPROCESS_UNIQUE_NAME NAME yes yes

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  12/17/2008 2:06:33 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_EXPORTPROCESS_UNIQUE_NAME WITH SCHEMABINDING
AS
select [NAME] from dbo.EXPORTPROCESS where [NAME] <> ''