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

Drop Primary Key Oracle

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

Before stepping into this article, gain knowledge about the primary key. Click here to know about the Primary key. Also, click the link to learn the concept for adding a Primary key to an existing table.

The concept of primary key and foreign key is really important, to interlink the data present in different tables in a database. With continuous increased data, we need to organize that data, just to make it easily accessible. We can also drop an already existing primary key in a table without actually affecting any values present in it. Follow the syntax below to perform a similar task.

Drop Primary Key in Oracle Syntax

Alter Table Table_Name
drop CONSTRAINT Constraint_name;

Oracle Drop Primary Key Example 1

We have a Stu table :

Oracle Drop Primary Key Example

wherein we have the Roll_No column as a primary key of that table. The that we used to create a Primary key is:

ALTER TABLE Stu
ADD CONSTRAINT stu_pk PRIMARY KEY (Roll_No);

Now to drop the primary key concept from a particular Roll_no column, we can write a code as:

Alter Table Stu
drop CONSTRAINT stu_pk;

Output

Oracle Drop Primary Key Example

Oracle Drop Primary Key Example 2

Let's consider a table Stu wherein Two columns are made as a Primary key. Roll_No and Stu_id are the names of those two columns. Code used to create them as a primary key is:

ALTER TABLE Stu
ADD CONSTRAINT stu_pk PRIMARY KEY (Roll_No, Stu_id);

Now, to drop both of the Primary keys of the table we can write the following code:

Alter Table Stu
drop CONSTRAINT stu_pk;

Output

Oracle Drop Primary Key Example

Related Content
Alter Table Add Primary Key Oracle
Oracle Create Table Primary Key
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