>>DECLARE @CONSTRAINT_NAME nvarchar(128)
>>
>>SELECT @CONSTRAINT_NAME = CONSTRAINT_NAME
>>  FROM INFORMATION_SCHEMA.KEY_USAGE
>>  WHERE ...
>>
>>DECLARE @sql varchar(4000)
>>SET @sql = 'ALTER TABLE DROP CONSTRAINT ' + @CONSTRAINT_NAME
>>EXECUTE (@sql)
>>