How can I get to know constraint name (given by us) in MySQL?

Question

alter table tut ADD Constraint MyUniqueness unique (tutorial_title ) ;
desc tut;

here I am not getting constraint name i.e. "MyUniqueness"

score 0 · Answer 1 · answered Sep 01 '20 at 20:52

0

DESCRIBE doesn't show constraints. Use SHOW CREATE TABLE.

SHOW CREATE TABLE tut;

answered Sep 01 '20 at 20:52

Barmar

I have posted the answer too, you can refer that – Anubhav Kr. Srivastava Sep 12 '20 at 16:02

score 0 · Answer 2 · edited Sep 03 '20 at 01:13

0

Got the answer:

select * 
from information_schema.table_constraints 
where table_name = "table_Name";

edited Sep 03 '20 at 01:13

GMB

answered Sep 01 '20 at 21:13

2 Answers2