This value is true if the database implicitly adds an index on the column that has a foreign key constraint added to it.
This value is true if the database implicitly adds an index on the column that has a foreign key constraint added to it.
The following SQL can be used to test the database. The last statement will fail with a message that there already is an index on the column.
CREATE TABLE parent (pk INT PRIMARY KEY); CREATE TABLE child (pk INT PRIMARY KEY, pk_parent INT NOT NULL); ALTER TABLE child ADD CONSTRAINT idx_child_pk_parent FOREIGN KEY (pk_parent) REFERENCES parent (pk); CREATE INDEX idx_child_pk_parent ON child (pk_parent);
Different databases require different SQL to alter a column's definition.
Different databases require different SQL to alter a column's definition. Uses the schema_name_opt defined in the adapter.
the name of the table with the column
the name of the column
the type the column is being altered to
the SQL to alter the column
Different databases require different SQL to alter a column's definition.
Different databases require different SQL to alter a column's definition.
the optional schema name to qualify the table name
the name of the table with the column
the name of the column
the type the column is being altered to
the SQL to alter the column
Concrete subclasses must define this method that returns a newly constructed, but uninitialized, concrete ColumnDefinition subclass for the given SQL data type and optional CharacterSet.
Concrete subclasses must define this method that returns a newly constructed, but uninitialized, concrete ColumnDefinition subclass for the given SQL data type and optional CharacterSet.
the column's data type
an optional CharacterSet
a newly constructed but uninitialized ColumnDefinition for the column_type
Given a check constraint, create a name for it, using a Name() if it is provided in the options.
Given a check constraint, create a name for it, using a Name() if it is provided in the options.
the table and columns the check constraint is on
a varargs list of CheckOptions
a Tuple2 with the calculated name or the overridden name from a Name and the remaining options
Different databases have different limitations on the GRANT statement.
Different databases have different limitations on the GRANT statement. Uses the schema_name_opt defined in the adapter.
the name of the table with the index
one or more objects to grant the new permissions to.
one or more GrantPrivilegeType objects describing the types of permissions to grant.
the SQL to grant permissions
Different databases have different limitations on the GRANT statement.
Different databases have different limitations on the GRANT statement.
the optional schema name to qualify the table name
the name of the table with the index
one or more objects to grant the new permissions to.
one or more GrantPrivilegeType objects describing the types of permissions to grant.
the SQL to grant permissions
Different databases require different SQL to lock a table.
Different databases require different SQL to lock a table.
the name of the table to lock
the SQL to lock the table
Different databases require different SQL to lock a table.
Different databases require different SQL to lock a table.
the optional schema name to qualify the table name
the name of the table to lock
the SQL to lock the table
Given a table name, column name and column data type, return a newly constructed and fully initialized ColumnDefinition.
Given a table name, column name and column data type, return a newly constructed and fully initialized ColumnDefinition. The class of the returned ColumnDefinition only depends upon the input column data type.
the name of the table the column is in
the column's name
the data type of the column
a list of column options customizing the column
a new ColumnDefinition
Return the SQL text in a foreign key relationship for an optional ON DELETE clause.
Return the SQL text in a foreign key relationship for an optional ON DELETE clause.
an Option[OnDelete]
Return the SQL text in a foreign key relationship for an optional ON UPDATE clause.
Return the SQL text in a foreign key relationship for an optional ON UPDATE clause.
an Option[OnUpdate]
Different databases require different SQL to drop a column.
Different databases require different SQL to drop a column. Uses the schema_name_opt defined in the adapter.
the name of the table with the column
the name of the column
the SQL to drop the column
Different databases require different SQL to drop a column.
Different databases require different SQL to drop a column.
the optional schema name to qualify the table name
the name of the table with the column
the name of the column
the SQL to drop the column
Different databases require different SQL to drop an index.
Different databases require different SQL to drop an index. Uses the schema_name_opt defined in the adapter.
the name of the table with the index
the name of the index
the SQL to drop the index
Different databases require different SQL to drop an index.
Different databases require different SQL to drop an index.
the optional schema name to qualify the table name
the name of the table with the index
the name of the index
the SQL to drop the index
Different databases have different limitations on the REVOKE statement.
Different databases have different limitations on the REVOKE statement. Uses the schema_name_opt defined in the adapter.
the name of the table with the index
one or more objects to grant the new permissions to.
one or more GrantPrivilegeType objects describing the types of permissions to grant.
the SQL to grant permissions
Different databases have different limitations on the REVOKE statement.
Different databases have different limitations on the REVOKE statement.
the optional schema name to qualify the table name
the name of the table with the index
one or more objects to grant the new permissions to.
one or more GrantPrivilegeType objects describing the types of permissions to grant.
the SQL to grant permissions
To properly quote table names the database adapter needs to know how the database treats unquoted names.
To properly quote table names the database adapter needs to know how the database treats unquoted names.