/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

9 votes300 views3 answers
Postgres make sql dump
SQL
0 vote248 views1 answer
Parsing float to int in mysql
SQL
1 vote302 views1 answer
Mysql last year
SQL
0 vote275 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote238 views1 answer
Big query add table rows to another table
SQL
4 votes264 views1 answer
Oracle error compilation line
SQL
5 votes252 views1 answer
Oracle list packages
SQL
4 votes251 views2 answers
Oracle set date format
SQL
0 vote257 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote272 views2 answers
Sql query in dax power bi
SQL

Share