/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 vote172 views1 answer
Best sql course
SQL
1 vote184 views1 answer
Apex ORA-20999
SQL
0 vote163 views1 answer
Drop all tables db2
SQL
0 vote175 views3 answers
Magento 2 order delete from db
SQL
0 vote183 views1 answer
Mysql cli output to a file
SQL
0 vote197 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote191 views1 answer
Drop view in mysql
SQL
0 vote158 views1 answer
Sql where time stamp is in between
SQL
0 vote164 views1 answer
No suitable driver found for sqlite
SQL
0 vote128 views1 answer
Flask_sqlalchemy install
SQL