dbo.members.members_ux

 

Object Type

Index

Datasource

IPMA

Database

controls

 

Properties

 

Unique

Yes

Cluster

No

Ignore Duplicate Keys

No

Non-Unique Options

 

Ignore Duplicate Rows

No

Allow Duplicate Rows

No

Columns
NAME
name
id

DDL

CREATE UNIQUE NONCLUSTERED INDEX members_ux
    ON dbo.members(name,id)
go