This category will hold examples for Oracle SQL.
Recently I had to drop some foreign key constraints on tables.
Below the SQL, which did the job for me. After 'drop constraint' you have to provide the name of a constraint you want to delete as it is maintained in table all_constraints.
- Hits: 8493
If you have to know the current database version, you can get this information using the following SQL.
- Hits: 7992
Page 3 of 3