Recent content by Radu

Thank you, but it appears that the query doesn't work for me. In the meantime I found one that works: select cols.column_name from user_cons_columns cols, user_constraints cons where cols.constraint_name = cons.constraint_name and cons.table_name = 'MY_TABLE_NAME' and...

I need a simple way of finding out (in Delphi) the primary key fields (their names) of an Oracle table. I have only the table name. I use Direct Oracle Access 3.4.6, Delphi 5 and Oracle 9i.