Dropping duplicate|redundant Unique Constraint from FILESTREAM table
- by electricsk8
I have a table with a FILESTREAM column, and it has two unique constraints specified for the same FILESTREAM column, ie:
ALTER TABLE [dbo].[TableName]
ADD CONSTRAINT [UQ_TableName_33C4988760FC61CA]
UNIQUE NONCLUSTERED ([GUID_Column]);
GO
ALTER TABLE [dbo].[TableName]
ADD CONSTRAINT [UQ_TableName_33C49887145C0A3F]
UNIQUE NONCLUSTERED ([GUID_Column]);
GO
I'd like to drop one of the unique constraints, as they are duplicates. However, when I try and drop one of the two duplicate constraints, I receive the following error.
"A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column."
Anyone know how to remove one of the two constraints?
