Here is my table:
Users (UserId, ApplicationId, UserName...)
I want the username to be unique by ApplicationId when I insert or update.
Can I create a unique key for the username to raise an error on insert or update ? If so, how can I limit the key to check a unique username by ApplicationId and not for all the table ?
Thanks in advance for your help.