I need to delete all constraints for a certain column. I found this related SO question but the indicated script actually deletes all constraints related to a certain table, not only for certain columns in it. Is there a way of dropping only constraints applied on a given column?
Alternatively, my bigger problem is, how to drop a column and all its constraints at once (without knowing the constraint's names)?