Unique constraint on multiple columns

by

If the table is already created in the database, then you can add a unique constraint later on by using this SQL query:

ALTER TABLE dbo.User
  ADD CONSTRAINT ucCodes UNIQUE (fcode, scode, dcode)

More Related Contents:

  1. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  2. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  3. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  4. Query times out when executed from web, but super-fast when executed from SSMS
  5. The request failed or the service did not respond in a timely fashion?
  6. If condition in SQL Server 2008
  7. Comma separated results in SQL
  8. sql server 2008 management studio not checking the syntax of my query
  9. Understanding PIVOT function in T-SQL
  10. Which are more performant, CTE or temporary tables?
  11. Using RegEx in SQL Server
  12. What is the best way to auto-generate INSERT statements for a SQL Server table?
  13. Import Excel spreadsheet columns into SQL Server database
  14. SqlServer: Login failed for user
  15. SQL Server 2008 Empty String vs. Space
  16. How do I use the CONCAT function in SQL Server 2008 R2?
  17. How do I get date/time information from a TIMESTAMP column?
  18. How to add xml encoding to xml Output in SQL Server
  19. How to: Create trigger for auto update modified date with SQL Server 2008
  20. What happens to the primary key Id when it goes over the limit?
  21. SQL Recursive CTE: Finding objects linked by property
  22. Convert decimal time to hours and minutes
  23. Sort Bullets in Database
  24. Converting Select results into Insert script – SQL Server
  25. FOR JSON PATH results in SSMS truncated to 2033 characters
  26. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  27. How to wait for 2 seconds?
  28. SQL Server 2008 can’t login with newly created user
  29. Find broken objects in SQL Server
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment