db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andy Jefferson <li...@datanucleus.org>
Subject Re: DatabaseMetaData.getIndexInfo() to get unique compound indexes
Date Tue, 28 Jun 2011 14:56:08 GMT
On Tuesday 28 Jun 2011 15:27:18 Andy
DataNucleus (http://www.datanucleus.org) Jefferson wrote:
> If I create a unique index like this
> ALTER TABLE {tblName} ADD CONSTRAINT {constrName} UNIQUE (col1, col2, col3)
> 
> and then call DatabaseMetaData.getIndexInfo()
> 
> it returns
>   tableCat        =
>   tableSchem      = null
>   tableName       = tblName
>   columnName      = col1
>   nonUnique       = true
>   ordinalPosition = 1
>   indexName       = SQL110628145704820
> 
>   tableCat        =
>   tableSchem      = null
>   tableName       = tblName
>   columnName      = col2
>   nonUnique       = true
>   ordinalPosition = 2
>   indexName       = SQL110628145704820
> 
>   tableCat        =
>   tableSchem      = null
>   tableName       = tblName
>   columnName      = col3
>   nonUnique       = true
>   ordinalPosition = 3
>   indexName       = SQL110628145704820

I ought to mention that on the same case MySQL returns the correct index name, 
and returns false on the "nonUnique", hence I have all information necessary

-- 
Andy

Mime
View raw message