Skip to content

Instantly share code, notes, and snippets.

@llagerlof

llagerlof/identify_foreign_key_oracle.sql

Created April 4, 2019 14:08
Show Gist options
  • Save llagerlof/2ed0af8eefb775cda9b08ebc8b31dbcc to your computer and use it in GitHub Desktop.
Save llagerlof/2ed0af8eefb775cda9b08ebc8b31dbcc to your computer and use it in GitHub Desktop.
Download ZIP
Identify a Oracle constraint or foreign key rule by its name.
Raw
identify_foreign_key_oracle.sql
/*
USE REF_CONSTRAINT IF ITS A FOREIGN KEY.
USE CONSTRAINT IF ITS ANOTHER TYPE OF CONSTRAINT.
*/
SELECT DBMS_METADATA.GET_DDL('REF_CONSTRAINT', 'FK_HUMAN_PLANET') FROM dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment