make unique row in mssql Example

gistfile1.txt

use DB
go

ALTER TABLE Tbl_SysUserIssueCategory
ADD CONSTRAINT UQ_SysUser_IssueCategory UNIQUE (SysUserId, IssueCategoryId);

remove 
=======


USE DB;
GO

ALTER TABLE Tbl_SysUserIssueCategory
DROP CONSTRAINT UQ_SysUser_IssueCategory;

check
==========  
SELECT 
    name, 
    type_desc 
FROM 
    sys.objects 
WHERE 
    parent_object_id = OBJECT_ID('Tbl_SysUserIssueCategory') 
    AND type_desc LIKE '%CONSTRAINT%';