SQL Server 2005 How Create a Unique Constraint?

by

The SQL command is:

ALTER TABLE <tablename> ADD CONSTRAINT
            <constraintname> UNIQUE NONCLUSTERED
    (
                <columnname>
    )

See the full syntax here.

If you want to do it from a Database Diagram:

  • right-click on the table and select ‘Indexes/Keys’
  • click the Add button to add a new index
  • enter the necessary info in the Properties on the right hand side:
    • the columns you want (click the ellipsis button to select)
    • set Is Unique to Yes
    • give it an appropriate name

More Related Contents:

  1. Foreign key constraint may cause cycles or multiple cascade paths?
  2. Turn off constraints temporarily (MS SQL)
  3. How to create a unique index on a NULL column?
  4. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  5. SQL Server 2008- Get table constraints
  6. Deferrable Constraints in SQL Server
  7. How to create a specific SQL Server stored procedure? [closed]
  8. Max sal to print base on manager_id
  9. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  10. Conversion failed when converting date and/or time from character string while inserting datetime
  11. Create a date from day month and year with T-SQL
  12. How should I pass a table name into a stored proc?
  13. Difference between left join and right join in SQL Server [duplicate]
  14. Where value in column containing comma delimited values
  15. How to use table variable in a dynamic sql statement?
  16. Search text in stored procedure in SQL Server
  17. Sequence vs identity
  18. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  19. Reference an alias elsewhere in the SELECT list
  20. Selecting first row per group
  21. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  22. How to find column names for all tables in all databases in SQL Server
  23. SQL Row_Number() function in Where Clause
  24. SQL update trigger only when column is modified
  25. SQL Server SELECT INTO @variable?
  26. Select a column if other column is null
  27. How to subtract 30 days from the current date using SQL Server
  28. Add a row number to result set of a SQL query
  29. Use one CTE many times
  30. How to do a case sensitive GROUP BY?

Leave a Comment