msSQL UNIQUE Column

So this is something that seems to have fairly poor documentation on. Setting a unique column in msSQL can be done by using the following command:

ALTER TABLE @tableName ADD UNIQUE(@column)

Leave a Reply

Your email address will not be published. Required fields are marked *