Timeline for How can I achieve a unique constraint with two fields? [duplicate]
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 31, 2013 at 13:50 | history | closed |
ypercubeᵀᴹ RolandoMySQLDBA András Váczi gbn Jon Seigel |
exact duplicate | |
| May 31, 2013 at 7:26 | history | edited | Yasir Arsanukayev |
edited tags
|
|
| May 31, 2013 at 7:24 | answer | added | Martin Smith | timeline score: 3 | |
| May 31, 2013 at 3:20 | comment | added | ProfK | Yeah @MartinSmith,please migrate your comment to the answer box. | |
| May 30, 2013 at 23:01 | comment | added | Paul White♦ | @MartinSmith You seem to have an answer here that is masquerading as a comment ;c) | |
| May 30, 2013 at 21:32 | history | edited | Kin Shah | CC BY-SA 3.0 |
added 1 characters in body; edited tags
|
| May 30, 2013 at 19:43 | comment | added | ProfK | @MartinSmith, I'm using MSSQL 2012 Express, so it should also be capable. I've just never heard of a filtered index until now, thanks. | |
| May 30, 2013 at 17:37 | comment | added | ypercubeᵀᴹ | SQL-Server and Postgres have partial indexes. In Oracle, similar functionality can be achieved as well. | |
| May 30, 2013 at 16:52 | review | Close votes | |||
| May 31, 2013 at 10:03 | |||||
| May 30, 2013 at 16:39 | comment | added | Martin Smith | What RDBMS are you using? In SQL Server 2008+ A unique filtered index can do this. | |
| May 30, 2013 at 16:38 | comment | added | ypercubeᵀᴹ | Also similar to this question: Custom unique column constraint, only enforced if one column has a specific value | |
| May 30, 2013 at 16:35 | history | asked | ProfK | CC BY-SA 3.0 |