V_WPRELATIONSHIP_NPA_UNIQUE_EIN
Used to enforce unique values on the WPRELATIONSHIP_NPA.EIN field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the WPRELATIONSHIP_NPA table.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EIN | nvarchar(30) |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| UIX_V_WPRELATIONSHIP_NPA_UNIQUE_EIN | EIN | yes | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/2/2010 7:12:19 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_WPRELATIONSHIP_NPA_UNIQUE_EIN WITH SCHEMABINDING
AS
select [EIN] from dbo.WPRELATIONSHIP_NPA where [EIN] <> ''