Unique Index creation

[krutoj_pablo]

Hi.

Is there any way to create unique index in a table using EA which consists of 2 or more columns ?

[«Midnight»]

Yes.

Create the columns as normal; check the Unique and Not Null boxes if and as appropriate for your model.

Once that's done and all is saved, open up the Operations dialog for the table (you can use the F10 shortcut as you would for a class). Create a new index - which is just an operation as far as this profile is concerned - by providing a name and selecting "unique" from the stereotype drop-down. You must now save the index by clicking the Save button.

Once you've saved the new index, click the Columns tab. Using the drop-down, select and save (with the button) each column in order. If you get the order wrong, use the 'hands' to make adjustments. Save your work and you're done!

Once you have this working, you can shortcut the process a bit. I'll leave you to experiment with this if and as you require.

David