Does creating a unique constraint on a column automatically create index?

sql-server, sql-server-2005

Solution

yes it does. See this

Problem

Consider this unique constraint: ``` ALTER TABLE Posts ADD CONSTRAINT UQ_Posts_Name UNIQUE (Name); ``` Does it automatically create index on `Name` column?

Original source

Related problems