I've always assumed that a unique index on a single column was superior to a unique column constraint since the former can be dropped and/or recreated, etc (e.g. in the future I decide that really it should be unique across two columns or really it doesn't need to be unique at all). Is there any downside to using a unique index in this way? Is it really all the same under the covers? Am I missing something? Thanks.