/SQL/Foreign key in oracle sql developer

Foreign key in oracle sql developer

Foreign key oracle

ALTER TABLE table_name
ADD CONSTRAINT constraint_name
   FOREIGN KEY (column1, column2, ... column_n)
   REFERENCES parent_table (column1, column2, ... column_n);

Example

ALTER TABLE products
ADD CONSTRAINT fk_supplier
  FOREIGN KEY (supplier_id)
  REFERENCES supplier(supplier_id);

Source: grepper.com

Similar codes

1 vote338 views1 answer
Mysql average of multiple columns
SQL
1 vote354 views1 answer
Sample clause in sql
SQL
11 votes344 views2 answers
MySQL DISTINCT
SQL
0 vote342 views1 answer
Database springboot
SQL
0 vote344 views4 answers
Mysql replace regex
SQL
2 votes364 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote352 views1 answer
Mysql grant user wildcard database
SQL
0 vote343 views1 answer
Mysql select row with min date
SQL
13 votes380 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote375 views1 answer
How to install postgresql on wsl
SQL