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