/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

11 votes172 views3 answers
How to get last row of table in sql
SQL
0 vote162 views1 answer
Can't connect to postgresql mac os
SQL
1 vote158 views1 answer
How to use a trigger to validate input data
SQL
0 vote161 views1 answer
Flask sqlalchemy update row
SQL
0 vote192 views2 answers
PostgreSQL having
SQL
3 votes199 views1 answer
Set default today mysql
SQL
1 vote179 views1 answer
Drop primary key oracle
SQL
0 vote186 views1 answer
How to run mysql on terminal mac
SQL
0 vote169 views1 answer
Mysql beautifier terminla
SQL
25 votes189 views4 answers
Metadata
SQL