InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:27:46 GMT20http://www.teradata.com/teradataforum/Topic10629-11-1.aspxOk, thanks.And I just looked into using dbc.indices, and that will work great for what I need. Thanks a lot!Wed, 20 Feb 2008 09:32:13 GMTnewerakbhttp://www.teradata.com/teradataforum/Topic10629-11-1.aspxINDEX_NAME would be NULL if the index wasn't given a name during the time of creation (which is purely optional in TD) ... (you can check the table DDL via the show table tablename) command to see if those indexes had a name or not.Wed, 20 Feb 2008 09:31:23 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic10629-11-1.aspxWell the samples that came with the driver included a file showing how to get index information, leading me to believe that it worked. But when I tried using getIndexInfo(), INDEX_NAME in the ResultSet was always null. I know the ResultSet was set correctly because TABLE_NAME and some other data was present, but the actual name of the index column(s) were not there.Maybe I'm having nomenclature issues...the Index that getIndexInfo() is talking about should be Teradata's Index, right...like the primary index? Or is it some other relational db feature with the same name?Wed, 20 Feb 2008 09:26:16 GMTnewerakbhttp://www.teradata.com/teradataforum/Topic10629-11-1.aspxAre you sure getIndexInfo() didn't work for you ?I recall my development team using something like that in the past to retrieve this information.Another way is to select from dbc.indices (make use of the uniqueflag column)Tue, 19 Feb 2008 22:06:26 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic10629-11-1.aspxI'm attempting to write a Java application which creates test data in a table specified by the user. But my app needs to know which columns need to be unique, and which make up the index and/or primary index of the table. Since the Teradata JDBC driver does not support getIndexInfo, is there another way I can obtain this information?Tue, 19 Feb 2008 10:44:13 GMTnewerakb