My question is how do we delete or remove all the constraints defined on a table in MySQL database at one go. Is there any possible way to do it with a single LOC or do we have to write instruction to remove each type of constraint individually. Could anyone help me out. A small script too would as it becomes too tedious to remember all the constraint names for a table and then remove them. Thanks.