Uses of Class
er.extensions.jdbc.ERXSQLHelper.ColumnIndex

Packages that use ERXSQLHelper.ColumnIndex

Package	Description
er.extensions.jdbc
er.extensions.migration	Migrations

Uses of ERXSQLHelper.ColumnIndex in er.extensions.jdbc

Methods in er.extensions.jdbc that return ERXSQLHelper.ColumnIndex

Modifier and Type	Method and Description
protected ERXSQLHelper.ColumnIndex[]	ERXSQLHelper.columnIndexesFromColumnNames(String... columnNames)

Methods in er.extensions.jdbc with parameters of type ERXSQLHelper.ColumnIndex

Modifier and Type	Method and Description
NSMutableArray<String>	ERXSQLHelper.columnNamesFromColumnIndexes(ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes) Returns the SQL expression for creating an index on the given set of columns
String	ERXSQLHelper.OracleSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.H2SQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.DerbySQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.FrontBaseSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.MySQLSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.PostgresqlSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.FirebirdSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.MicrosoftSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.NoSQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.DB2SQLHelper.sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes) Returns the SQL expression for creating a unique index on the given set of columns
String	ERXSQLHelper.OracleSQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.H2SQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.DerbySQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.FrontBaseSQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.MySQLSQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.PostgresqlSQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes) Creates unique index; stolen from the derby helper
String	ERXSQLHelper.FirebirdSQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes) Creates unique index; stolen from the derby helper
String	ERXSQLHelper.MicrosoftSQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)
String	ERXSQLHelper.DB2SQLHelper.sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes)

Uses of ERXSQLHelper.ColumnIndex in er.extensions.migration

Methods in er.extensions.migration that return ERXSQLHelper.ColumnIndex

Modifier and Type	Method and Description
ERXSQLHelper.ColumnIndex[]	ERXMigrationIndex.columns() Returns the columns being indexed.

Methods in er.extensions.migration with parameters of type ERXSQLHelper.ColumnIndex

Modifier and Type	Method and Description
void	ERXMigrationTable.addIndex(boolean create, String indexName, ERXSQLHelper.ColumnIndex... columnIndexes) Executes the SQL operations to add an index.
void	ERXMigrationTable.addIndex(String indexName, ERXSQLHelper.ColumnIndex... columnIndexes) Executes the SQL operations to add an index.
void	ERXMigrationTable.addUniqueIndex(boolean create, String indexName, ERXSQLHelper.ColumnIndex... columnIndexes) Executes the SQL operations to add a unique index.
void	ERXMigrationTable.addUniqueIndex(String indexName, ERXSQLHelper.ColumnIndex... columnIndexes) Executes the SQL operations to add a unique index.

Constructors in er.extensions.migration with parameters of type ERXSQLHelper.ColumnIndex

Constructor and Description
ERXMigrationIndex(String name, boolean unique, ERXSQLHelper.ColumnIndex... columns) Creates a new index reference.