Add foreign key in existing table Mysql

mysql Share on :

ALTER TABLE 
ContactDetails 
ADD 
EmployeeId INT UNSIGNED NOT NULL;

ALTER TABLE 
ContactDetails 
ADD 
CONSTRAINT fk_EMP_CONTACT FOREIGN KEY (EmployeeId) REFERENCES Employee(Id);

You can use the above queries to add foreign key constraints to an existing table. In the code snippet, we are assigning 'EmployeeId' as a foreign key in 'ContactDetails' table.

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Add a Boolean column in MySQL table with default value
Create table with constraints MySQL query
Insert data into table mysql query
Rename table MySQL
Remove or drop table MySQL
Delete a column from Table MySQL
Show all column names of a table MySql query

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer