/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 vote271 views1 answer
Sql server get users
SQL
2 votes280 views1 answer
Sql missing records from another table
SQL
0 vote281 views1 answer
Date on SQL
SQL
-1 vote293 views8 answers
Create Trigger in phpMyAdmin
SQL
11 votes285 views1 answer
Oracle view ddl
SQL
-2 votes270 views1 answer
Modify column name in tsql
SQL
4 votes270 views1 answer
Postgresql change default value
SQL
9 votes530 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote312 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
1 vote306 views1 answer
Mysql text to decimal
SQL