getIndexInfo Method (SQLServerDatabaseMetaData)

  • Article

Retrieves a description of the indexes and statistics for the given table.

Syntax

public java.sql.ResultSet getIndexInfo(java.lang.String cat,
                                       java.lang.String schema,
                                       java.lang.String table,
                                       boolean unique,
                                       boolean approximate)

Parameters

cat

A String that contains the catalog name.

schema

A String that contains the schema name.

table

A String that contains the table name.

unique

true if only indexes for unique values are returned. false if all indexes are returned.

approximate

true if the results reflect approximate or out-of-date values. false if the results are accurate.

Return Value

A SQLServerResultSet object.

Exceptions

SQLServerException

Remarks

This getIndexInfo method is specified by the getIndexInfo method in the java.sql.DatabaseMetaData interface.

The result set returned by the getIndexInfo method will contain the following information:

Name

Type

Description

TABLE_CAT

String

The name of the database in which the specified table resides.

TABLE_SCHEM

String

The schema for the table.

TABLE_NAME

String

The name of the table.

NON_UNIQUE

boolean

Indicates whether the index values can be non-unique.

INDEX_QUALIFIER

String

The name of the index owner. It will be null when TYPE is tableIndexStatistic.

INDEX_NAME

String

The name of the index.

TYPE

short

The type of the index. It can be one of the following values:

tableIndexStatistic (0)

tableIndexClustered (1)

tableIndexHashed (2)

tableIndexOther (3)

ORDINAL_POSITION

short

The ordinal position of the column in the index. The first column in the index is 1.

COLUMN_NAME

String

The name of the column.

ASC_OR_DESC

String

The order used in the collation of the index. It can be one of the following values:

A (ascending)

D (descending)

NULL (not applicable)

Note

SQL Server always returns "A".

CARDINALITY

int

The number of rows in the table or unique values in the index.

PAGES

int

The number of pages used to store the index or table.

FILTER_CONDITION

String

The filter condition.

Note

SQL Server always returns null.

Note

For more information about the data returned by the getIndexInfo method, see "sp_indexes (Transact-SQL)" in SQL Server Books Online.

Example

The following example demonstrates how to use the getIndexInfo method to return information about the indexes and statistics of the Person.Contact table in the SQL Server 2005 AdventureWorks sample database.

public static void executeGetIndexInfo(Connection con) {
   try {
      DatabaseMetaData dbmd = con.getMetaData();
      ResultSet rs = dbmd.getIndexInfo("AdventureWorks", "Person", "Contact", false, true);
      ResultSetMetaData rsmd = rs.getMetaData();

      // Display the result set data.
      int cols = rsmd.getColumnCount();
      while(rs.next()) {
         for (int i = 1; i <= cols; i++) {
            System.out.println(rs.getString(i));
         }
      }
      rs.close();
   } 

   catch (Exception e) {
      e.printStackTrace();
   }
}

See Also

Reference

SQLServerDatabaseMetaData Class

Concepts

SQLServerDatabaseMetaData Methods

SQLServerDatabaseMetaData Members