/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

3 votes231 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote309 views1 answer
Create view in sql server that contain multiple select statements
SQL
2 votes225 views2 answers
Get all tables using like
SQL
1 vote234 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote236 views1 answer
Selecting from a view SQL
SQL
11 votes191 views1 answer
Reset identity sql server
SQL
0 vote234 views1 answer
Clear query cache sql server
SQL
1 vote230 views3 answers
How to get date in sql
SQL
49 votes234 views6 answers
Get duplicate records in sql
SQL
2 votes287 views3 answers
Sql delete duplicate
SQL