Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Teradata Primary Index

843859Feb 19 2008 — edited Nov 20 2014
I'm working with a Teradata database, and can connect and work with data using JDBC without issue. I'm coding an app to automatically create test data in a table specified by the user. The problem is, the Teradata JDBC driver does not support the getIndexInfo() method on a DatabaseMetaData object, which means I cannot determine which columns are unique, and which columns comprise the index of the table. I need this info to determine what type of data is inserted.

Can anyone think of some other method I could use, to logically determine which columns make up the index? Remember, this is the primary index I'm concerned with, not the primary key. These tables do not have primary keys.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2008
Added on Feb 19 2008
27 comments
329 views