Paul - The Programmer

simple & stupid
setup http proxy server for ppm
my first Perl proxy server

Get oracle table primary key info

paul posted @ Sat, 25 Oct 2008 01:10:39 +0800 in coding life , 1504 readers

    SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
    FROM all_constraints cons, all_cons_columns cols
    WHERE cols.table_name = 'TABLE_NAME'
    AND cons.constraint_type = 'P'
    AND cons.constraint_name = cols.constraint_name
    AND cons.owner = cols.owner
    ORDER BY cols.table_name, cols.position;

-- What a terrible statement. 

-- Reference link: http://www.techonthenet.com/oracle/questions/find_pkeys.php

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License.
  • No match
  • No match

Login *


loading captcha image...
(type the code from the image)
or Ctrl+Enter