I'm new using this program, how do you define Foreign key in oracle SQL developer?
How to set Foreign key in oracle SQL developer?
1
asked by anonymous 25.11.2017 / 18:29
1 answer
1
Right-click the table in which you want to add FK, select the menu Constraint and then select Add Foreign Key .
Inthewindowthatopens,fillintheinformation:
- Name:nameofyourFK
- ColumnName:isthecolumnofyourforeignkeytable
- ReferenceTableName:istheprimarykeytable
- ReferencingColumn:istheprimarykeyofyourreferencetable
ClicktheApplybutton
Reference:
- DOCS.ORACLE, Database 2 Day Developer's Guide
25.11.2017 / 18:43