Insert Update Table Data structure

Here you can get the mysql structure for add/drop Foreign Key in table.

Foreign Key Table Structure

Tablename

Contraint(Optional)

Foreign Key

Reference Table

Reference Field Name

Query Output:

ALTER TABLE <table_name> ADD CONSTRAINT <contraint_name> FOREIGN KEY(<field name>) REFERENCES <Reference_table_name>(<ReferenceFieldName>);

Drop Foreign Key Table Structure

Tablename

Contraint(Optional)

Field Name

Query Output:

ALTER TABLE <table_name> DROP INDEX <field_name>;