| workbench.db.IndexReader
All known Subclasses: workbench.db.JdbcIndexReader,
IndexReader | public interface IndexReader (Code) | | author: support@sql-workbench.net |
buildCreateIndexSql | String buildCreateIndexSql(TableIdentifier table, String indexName, boolean unique, String[] columnList)(Code) | | Build a SQL statement (from scratch) to create a new index on the given table.
Parameters: table - - The table for which the index should be constructed Parameters: indexName - - The name of the Index Parameters: unique - - Should the index be unique Parameters: columnList - - The columns that should build the index |
getIndexInfo | ResultSet getIndexInfo(TableIdentifier table, boolean unique) throws SQLException(Code) | | Replacement for the JDBC's getIndexInfo method.
After the returned ResultSet has been processed, indexInfoProcessed() has to be called!
The TYPE column may not be an integer value but a String value that indicates
the type of the index in plain text. So the column "TYPE" from the result set
should always be accessed using getObject("TYPE")
See Also: IndexReader.indexInfoProcessed() |
getIndexSource | StringBuilder getIndexSource(TableIdentifier table, DataStore indexDefinition, String tableNameToUse)(Code) | | Get the SQL source for all indexes defined in indexDefinition.
If tableNameToUse is non-null then that name will be used instead
of the name of the TableIdentifier
|
processIndexList | void processIndexList(TableIdentifier table, Collection<IndexDefinition> indexDefinitions)(Code) | | Post-Process the index definitions contained in the List
This can be used to e.g. retrieve additional index information
that can't be read with getIndexInfo()
|
|
|