getIndexInfo Method (SQLServerDatabaseMetaData)
Retrieves a description of the indexes and statistics for the given table.
public java.sql.ResultSet getIndexInfo(java.lang.String cat,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
Parameter
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.
Rückgabewert
A SQLServerResultSet object.
Ausnahmen
Hinweise
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)
Hinweis:
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.
Hinweis:
SQL Server always returns null.
Hinweis
For more information about the data returned by the getIndexInfo method, see "sp_indexes (Transact-SQL)" in SQL Server Books Online.
Beispiel
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();
}
}
Siehe auch
Verweis
SQLServerDatabaseMetaData Class
Konzepte
SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members