/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 vote202 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote204 views1 answer
Where in clause tsql
SQL
4 votes180 views1 answer
Sql group by year
SQL
0 vote158 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
2 votes254 views1 answer
How to check grants on a package in oracle
SQL
0 vote219 views1 answer
Flask sqlalchemy session delete
SQL
0 vote217 views1 answer
Mysql insert into select transaction c#
SQL
0 vote209 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote185 views1 answer
Implizite joins sql
SQL
1 vote205 views1 answer
Liquibase alter column type / length
SQL

Share