Oracle Database
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.
Alter Table
a_table
drop constraint
fk_any_table_ref;
- Hits: 8909
Recently I had to check over and over again, if tables, which I needed for testing are existing in an Oracle database.
Since checking for existance and completion repeatedly involved the same tasks I decided to implement little PL SQL script, which does the task for me.
SQL
- Hits: 5008
If you have to know the current database version, you can get this information using the following SQL.
SQL
- Hits: 8418
Subcategories
Oracle SQL Article Count: 8
This category will hold examples for Oracle SQL.
Oracle SQL Developer Article Count: 4
This category will hold Oracle SQL Developer specific articles.
Oracle PL SQL Article Count: 6
A category holding articles for Oracles programming language PL SQL.
Page 3 of 6