Results 1 to 3 of 3

Thread: Oracle constraints

  1. #1
    Join Date
    Dec 2004
    Posts
    37

    Oracle

    I was just wondering how does it?

    Thanks in advance.
    Last edited by 182; 01-07-2005 at 02:02 PM.

  2. #2
    Join Date
    Feb 2003
    Posts
    1,048
    It stores it in system tables. Take a look at the user_constraints view.

    Select *
    From user_constraints

  3. #3
    Join Date
    Mar 2003
    Posts
    468
    you can also look at all primary key constraints on the system through dba_constraints where constraint_type = 'P'

    and if you care to look for the columns on the primary key look at the dba_cons_columns view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •