Skip to content

Instantly share code, notes, and snippets.

@programaker

programaker/oracle-list-all-constraints.sql

Created December 14, 2009 13:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save programaker/256045 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save programaker/256045 to your computer and use it in GitHub Desktop.
Download ZIP
list all constraints of a table in oracle
Raw
oracle-list-all-constraints.sql
select * from all_constraints where table_name = '<table_name>'
-- where constraint_type = 'P' -> primary key
-- = 'R' -> foreign keys
-- = 'C' -> constraints like not null
@Megh05

Megh05 commented Aug 19, 2019

Copy link
Copy Markdown

displaying -- not ended properly --

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment