/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 vote110 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote116 views1 answer
Postgresql not in alternative
SQL
0 vote110 views1 answer
Low level operator in dbms
SQL
0 vote110 views1 answer
SQL Query to delete all the tables in a database
SQL
-1 vote60 views2 answers
Datetime sql server week
SQL
0 vote117 views1 answer
How to input data as id in database sql c#
SQL
1 vote103 views1 answer
Mysql batch insert
SQL
0 vote109 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote119 views1 answer
Query builder doctrien return sql
SQL
35 votes120 views5 answers
Sql alter column
SQL

Share