Getting Candidate Keys for a Table?
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Amar_Sagoo
Posted On:   Wednesday, March 6, 2002 07:42 AM

Hi,

Does anyone know a way of getting a list of all candidate keys for a table? (all "UNIQUE" sets of columns defined when creating a table).


I looked in DatabaseMetaData, but there you can only get a list of primary key fields.


I'm using Java 1.3.1 with a PostgreSQL backend.


Cheers
Amar

About | Sitemap | Contact