/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

2 votes144 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote143 views1 answer
What is a Database?
SQL
0 vote132 views1 answer
Name '_mysql' is not defined
SQL
0 vote153 views1 answer
Postgresql print sessions using the database
SQL
0 vote139 views2 answers
Oracle create chain rule
SQL
-2 votes241 views1 answer
How-to-remove-mysql-root-password
SQL
-1 vote148 views3 answers
How to restart mysql in linux
SQL
1 vote153 views1 answer
How to select multiple columns from different tables in mysql
SQL
1 vote144 views1 answer
Truncate left characters mysql
SQL
0 vote149 views1 answer
Multiple tricky query in sql server
SQL