Skip to main content
Home
  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact
programsbuzz facebook programsbuzz twitter programsbuzz linkedin
  • Log in

Main navigation

  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact

Add Foreign Key in Oracle Alter Table

Profile picture for user akshita.goel
Written by akshita.goel on 12/24/2021 - 11:31

Before stepping into this, you need to get a clear vision of what foreign key is. Click here to explore foreign keys. 

In the previous articles, we have discussed how we can add a primary key and drop a primary key to an existing Table. Now, the question arises:

How to Add Foreign Key in Existing Table in SQL ?

Several times it happens, that we have explored different kinds of data that are interlinked. So, we always use to attach that kind of data through a Foreign key. For an instance, a table is present in the database that contains information about the different students. Now, an examination is declared that needs a couple of students to attend the same. That means every student will be allotted a partner for that. We can make another table named Partner and can link the two tables with common Roll_No. 

Follow the Stu table as below:

alter table add constraint foreign key oracle

Now the Partner table can be as follows:

alter table add foreign key oracle

In the above table, you can see, that a person with 180  as a Roll_no has Sunita as a partner. So, we got to know here, that the Roll_No column of the Stu table can act as a Primary key for Roll_No as a foreign key in the Partner table. 

To add a Foreign key in the already existing table follow the syntax below:

Syntax

alter table Table
Add Constraint Constraint_Name 
FOREIGN KEY(common_attribute) REFERENCES Primary_Key_TABLE (Common_attribute);
  1. Partner is the Table name.
  2. Partner_fk is the Constraint Name.
  3. Roll_No is the common column in both tables.

Oracle Add Foreign Key in Existing Table Example

alter table partner
Add Constraint Partner_fk 
FOREIGN KEY(Roll_No) REFERENCES Stu(Roll_No);

Output

oracle Add Foreign Key in Existing Table

Related Content
Oracle Foreign Key
How to Drop Foreign Key in Oracle
Oracle Tutorial
  • Log in or register to post comments

Choose Your Technology

  1. Agile
  2. Apache Groovy
  3. Apache Hadoop
  4. Apache HBase
  5. Apache Spark
  6. Appium
  7. AutoIt
  8. AWS
  9. Behat
  10. Cucumber Java
  11. Cypress
  12. DBMS
  13. Drupal
  14. GitHub
  15. GitLab
  16. GoLang
  17. Gradle
  18. HTML
  19. ISTQB Foundation
  20. Java
  21. JavaScript
  22. JMeter
  23. JUnit
  24. Karate
  25. Kotlin
  26. LoadRunner
  27. matplotlib
  28. MongoDB
  29. MS SQL Server
  30. MySQL
  31. Nightwatch JS
  32. PactumJS
  33. PHP
  34. Playwright
  35. Playwright Java
  36. Playwright Python
  37. Postman
  38. Project Management
  39. Protractor
  40. PyDev
  41. Python
  42. Python NumPy
  43. Python Pandas
  44. Python Seaborn
  45. R Language
  46. REST Assured
  47. Ruby
  48. Selenide
© Copyright By iVagus Services Pvt. Ltd. 2023. All Rights Reserved.

Footer

  • Cookie Policy
  • Privacy Policy
  • Terms of Use