In SQL Server I deploy a table with a
CREATE TABLE [dbo].[Something] ( [IdentityId] UNIQUEIDENTIFIER UNIQUE NOT NULL DEFAULT NEWID() -- Whatever else... )
and this makes SQL Server to create a unique index to back the constraint. That index will have name generated automatically and looking something like
UQ means "unique" and all the rest is well, random stuff to me. If I have two unique constraints for the same table they just look like two random strings which is not very convenient.
Is it possible to specify the name for the index which is created under the hood when a unique constraint is created?