JDBC Metada Retrieves Constraint Information

Question

I need information about the name of the table and column on behalf of the constraint.

there is someone similar to connection.getMetadata (). getX for restriction information?

my test case is in an Oracle database, but my best solution I just want to solve with jdbc

+5

jrey Jul 15 '12 at 18:36

2 answers

:

select 
    CONSTRAINT_NAME,
    CONSTRAINT_TYPE,
    TABLE_NAME,
    ...
from
    USER_CONSTRAINTS
where
    CONSTRAINT_NAME like concat(?, '%');

+3

Ravinder Reddy 15 . '12 18:46

Mark Rotteveel · Accepted Answer · 2012-07-16T17:30:37+0000

If you are talking about foreign keys and primary key constraints. DatabaseMetaDataIt provides methods to retrieve this information: you can use getImportedKeys(..)and getCrossReference(..)for external keys and getPrimaryKeys(..)and getExportedKeys(..)for primary keys.

Just be careful how you use them: getCrossReference(..)and getExportedKeys, in my opinion, a little intuitive.

, getIndexInfo(..) true unique.