read database schema information from jdbc

[Quick Function]

Here is my sql to create a table (B is another table)

create table A
(
ID NUMBER(10)
CONSTRAINT A_NN NOT NULL
CONSTRAINT A_id_FK REFERENCES B(ID),
Data NUMBER(10),
THRESHOLD NUMBER(10),
CONSTRAINT A_PK PRIMARY KEY (ID)
);

Can I retrieve all the constraint information (not null, foreign key,
pk...) from jdbc? Using a DatabaseMetaData?

Thanks,

qq

 

[Roedy Green]

Can I retrieve all the constraint information (not null, foreign key,
pk...) from jdbc? Using a DatabaseMetaData?

Look at the methods. I don't see much interesting other than whether
the field is allowed to be null.

Look also at ParameterMetaData and ResultSetMetaData