/SQL/Alter foreign key

Alter foreign key

Alter table add foreign key mysql

ALTER TABLE orders
ADD 
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

9

Add constraint fk

ALTER TABLE Orders
ADD CONSTRAINT FK_PersonOrder
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);

4

Alter foreign key

ALTER TABLE Employee
ADD FOREIGN KEY (DeptNo) REFERENCES Department(DeptNo);

1

Source: computerscienceai.com

Similar codes

3 votes176 views1 answer
Oracle transaction commit rollback example
SQL
27 votes228 views6 answers
Sql update record
SQL
2 votes234 views2 answers
Mysql search for column name in all tables
SQL
0 vote167 views1 answer
Call scalar valued function sql
SQL
0 vote221 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
2 votes194 views1 answer
Sql server current date minus 5 years
SQL
0 vote177 views1 answer
How to get inserted id in sql server
SQL
0 vote238 views1 answer
Postgres get running query
SQL
0 vote304 views1 answer
Oracle convert int to date
SQL
0 vote246 views1 answer
MySQL - How to find word with the most similar beginning
SQL

Share