/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

1 vote323 views1 answer
Mysql f# examples
SQL
1 vote353 views1 answer
Print year of a date sql
SQL
2 votes383 views2 answers
Null column to 0 in mysql
SQL
6 votes358 views3 answers
Rename column ORACLE
SQL
1 vote340 views3 answers
Divide by zero error in sql
SQL
0 vote358 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote366 views1 answer
Creating sqeuence in oracle database
SQL
0 vote334 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote395 views1 answer
Why do we need data structure in sql
SQL
0 vote292 views1 answer
Plsql trigger insert update
SQL

Share