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