Teradata Primary Index
843859Feb 19 2008 — edited Nov 20 2014I'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.