/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

0 vote313 views2 answers
Athena drop partition
SQL
1 vote359 views4 answers
How to check table in postgresql from terminal
SQL
4 votes328 views1 answer
Mysql query first character
SQL
10 votes301 views2 answers
Sql rtrim
SQL
0 vote340 views1 answer
Primary key start from number
SQL
1 vote320 views1 answer
Find a column in all tables postgres
SQL
2 votes337 views2 answers
Postgresql get table names
SQL
0 vote323 views1 answer
Enable sql server full text indexing
SQL
6 votes297 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
1 vote307 views2 answers
Mysql show views
SQL

Share