/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 votes205 views4 answers
Show sql server database
SQL
1 vote218 views1 answer
Sqlalchemy order_by
SQL
0 vote232 views1 answer
Tsql delete all rows
SQL
0 vote242 views1 answer
Select new table sql
SQL
1 vote223 views1 answer
Oracle sql first day of year
SQL
1 vote202 views2 answers
Pl sql case
SQL
8 votes234 views2 answers
Mysql grant all privileges to user from any host
SQL
17 votes221 views6 answers
Sql select distinct
SQL
14 votes232 views6 answers
Auto_increment mysql
SQL
0 vote221 views1 answer
How to check xampp mysql password
SQL

Share