oracle drop default value 1

oracle drop default value

ALTER TABLE Employees MODIFY Salary DROP DEFAULT;

Here is what the above code is Doing:
1. We’re creating a new table called Employees_new.
2. We’re copying all the data from the Employees table into the Employees_new table.
3. We’re dropping the Employees table.
4. We’re renaming the Employees_new table to Employees.
5. We’re adding a default value of 0 to the Salary column.

Similar Posts