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