/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

7 votes357 views2 answers
Oracle foreign key reference table
SQL
0 vote356 views1 answer
Oracle DROP PROGRAM
SQL
12 votes351 views1 answer
Psql drop column
SQL
2 votes338 views2 answers
Postgres set user as superuser
SQL
8 votes413 views2 answers
Default sql server port
SQL
3 votes372 views1 answer
Kill mysql processlist in whose time more than 200
SQL
1 vote350 views1 answer
Oracle sql create view
SQL
0 vote375 views1 answer
Shortcut run sql pgadmin
SQL
0 vote383 views1 answer
Sql max of two values
SQL
2 votes350 views3 answers
Oracle show column of table
SQL