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