CODEWITHSUNDEEP
sql-servert-sql
variable
variable

Reputation: 9664

Can auto creation of unique index for unique constraint be disabled?

Creating unique constraint auto creates an unique index.

Is there any way to disable the creation of the index as I dont need an index on this column.

Upvotes: 0

Views: 62

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89061

Is there any way to disable the creation of the index as I dont need an index on this column.

No. Because as you guessed, the index is responsible for ensuring uniqueness. Ie the Unique Constraint is implemented by creating a unique BTree index.

Upvotes: 3

Related Questions