Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/StackDBAs/status/991170736797683712
Formatting, sql-server tag
Source Link
LowlyDBA - John M
LowlyDBA - John M
  • 11.1k
  • 11
  • 46
  • 63

Looking into the Microsoft documentation, it says when a unique constraint is created, a unique index is created automatically. 

Is there a trickstrick/workaroundsworkaround to have a unique constraint and NOT have a unique index, so it does not take space  ?

Looking into Microsoft documentation, it says when unique constraint is created, unique index is created automatically. Is there a tricks/workarounds to have unique constraint and NOT have unique index so it does not take space  ?

Looking into the Microsoft documentation, it says when a unique constraint is created, a unique index is created automatically. 

Is there a trick/workaround to have a unique constraint and NOT have a unique index, so it does not take space?

Source Link
Aleksey Vitsko
Aleksey Vitsko
  • 6.2k
  • 6
  • 40
  • 72

Is there any way to have Unique Constraint and NOT have Unique Index?

Looking into Microsoft documentation, it says when unique constraint is created, unique index is created automatically. Is there a tricks/workarounds to have unique constraint and NOT have unique index so it does not take space ?