| How to Add Unique Constraint for multiple columns in SQL Server |
|
From time to time you may need to modify your database structure to add unique constraint for multiple columns. Here's how to do it: SYNTAX: ALTER TABLE tblOperationMaintenance ADD CONSTRAINT UQ_tblOperationMaintenance UNIQUE NONCLUSTERED ( [TaskListID], [GrpCounter], [OperationID], [MaintenanceID] ) GO
|