Constrain non-key column to have unique values?

[Matt Benic]

Is it possible to set a column in a table to have unique values without including it in the key? I have a table "locales" with two columns, "locale_id" and "name". While I want "locale_id" to be the key column used for lookups, I also want to ensure that "name" remains unique. Setting the "name" column as a key column seems to result in the id/name combination being constrained as unique but not the individual column.

Thanks