/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

0 vote328 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote354 views3 answers
How to run sql query
SQL
56 votes628 views5 answers
Psql create user
SQL
2 votes354 views3 answers
Sql truncate table
SQL
18 votes328 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote337 views2 answers
Mysql unique two columns
SQL
2 votes344 views1 answer
Sql finding longest and shortest names in a fleld
SQL
3 votes344 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote321 views1 answer
Get first monday of month sql
SQL
0 vote320 views1 answer
Mysql select where text contains
SQL