UNIQUE Column Restraint: how to determine?

[HankFay]

I've found how to "read" all the column restraints except this one: UNIQUE

I realize an index tag is created by that name as UNIQUE (and if an index already exists for that field it makes it UNIQUE -- I haven't checked what happens if the existing index has a different index expression).

But that's a bit difficult to check in a large model for every field to find out if it's UNIQUE. Is there another way that I missed?

thanks,

Hank

[barrymavin]

Hi Hank

The only way to determine if a column is unique is open the table and check the indexes to see if there is an index tag and its unique.
https://www.lianja.com/doc/index.php/TAGUNIQUE()

or alternatively look at sysindexinfo.
https://www.lianja.com/doc/index.php/SYSINDEXINFO

[HankFay]

That makes sense: it's really about the index in any case.

In the previous reality, I put a field in our DD table for fields to optionally pick an "Index" with several choices, one of which was Candidate. Of course this wasn't a field attribute at all, but just a quick way for the data designer to get an index on the field without having to switch the UI they were already in (in xCase).

thanks,

Hank