>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)
>