V_DATAFORMTEMPLATECATALOG_UNIQUE_LOADPROCEDURE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOADPROCEDURE | nvarchar(128) |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| UIX_V_DATAFORMTEMPLATECATALOG_UNIQUE_LOADPROCEDURE | LOADPROCEDURE | yes | yes |
Definition
Copy
create view [dbo].[V_DATAFORMTEMPLATECATALOG_UNIQUE_LOADPROCEDURE] with schemabinding
as
--Used to enforce unique LOADPROCEDURE while allowing empty values
select LOADPROCEDURE from dbo.DATAFORMTEMPLATECATALOG where LOADPROCEDURE <> '';