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