0

I would like to both see the constraints that I have added to a table and modify them. How can I do this? It is not letting me use ALTER TABLE user MODIFY CONSTRAINT userCreation;

random_0620
  • 1,636
  • 5
  • 23
  • 44
  • If you read the duplicate link, you will see that you need to first drop/remove the old constraint, then add a new one. I'm not sure that MySQL has a `MODIFY CONSTRAINT` capability. – Tim Biegeleisen Jun 11 '17 at 23:38
  • to check all your constrains try `SHOW CREATE TABLE yourTableName;` – JEET ADHIKARI Jun 11 '17 at 23:39

0 Answers0