public class MSSQLGenerator extends AbstractSQLGenerator
Constructor and Description |
---|
MSSQLGenerator() |
Modifier and Type | Method and Description |
---|---|
void |
alterTableAddColumn(SQLBatch sqls,
java.lang.String table,
java.lang.String column,
TableColumnDataType dataType,
java.lang.Object defaultValue,
boolean notNull) |
void |
alterTableAddKey(SQLBatch sqls,
java.lang.String table,
ConstraintType constraintType,
java.lang.String constraintName,
java.lang.String columns,
java.lang.String additional) |
void |
alterTableAlterColumn(SQLBatch sqls,
java.lang.String table,
java.lang.String column,
TableColumnDataType dataType,
java.lang.Object defaultValue,
boolean changeNotNull,
boolean shouldBeNotNull)
Parameter notNull may be null if state of "not null constraint" is not to be changed
|
void |
alterTableDropKey(SQLBatch sqls,
java.lang.String table,
ConstraintType constraintType,
java.lang.String constraintName) |
void |
alterTableSetNotNull(SQLBatch sqls,
java.lang.String table,
java.lang.String column,
TableColumnDataType currentDataType,
java.lang.Object currentDefaultValue,
boolean notNull)
MSSQL does not support only not null constraint change
|
boolean |
areConstraintsViolateColumnDataTypeChange()
Note!
|
void |
createSequence(SQLBatch sqls,
java.lang.String name) |
void |
createTable(SQLBatch sqls,
Table table) |
void |
dropSequence(SQLBatch sqls,
java.lang.String sequenceToDrop) |
void |
dropTable(SQLBatch sqls,
java.lang.String tableToDrop) |
DatabaseSchema |
scanDatabase(SQLConnector connector,
SQLScannerFilter filter) |
alterTableAddForeignKey, alterTableAddPrimaryKey, alterTableAddUniqueKey, alterTableDropColumn, alterTableDropForeignKey, alterTableDropPrimaryKey, alterTableDropUniqueKey, createIndex, dropIndex
public boolean areConstraintsViolateColumnDataTypeChange()
AbstractSQLGenerator
areConstraintsViolateColumnDataTypeChange
in class AbstractSQLGenerator
public void createTable(SQLBatch sqls, Table table)
createTable
in class AbstractSQLGenerator
public void createSequence(SQLBatch sqls, java.lang.String name)
createSequence
in class AbstractSQLGenerator
public void alterTableAddKey(SQLBatch sqls, java.lang.String table, ConstraintType constraintType, java.lang.String constraintName, java.lang.String columns, java.lang.String additional)
alterTableAddKey
in class AbstractSQLGenerator
public void alterTableDropKey(SQLBatch sqls, java.lang.String table, ConstraintType constraintType, java.lang.String constraintName)
alterTableDropKey
in class AbstractSQLGenerator
public void alterTableAddColumn(SQLBatch sqls, java.lang.String table, java.lang.String column, TableColumnDataType dataType, java.lang.Object defaultValue, boolean notNull)
alterTableAddColumn
in class AbstractSQLGenerator
public void alterTableAlterColumn(SQLBatch sqls, java.lang.String table, java.lang.String column, TableColumnDataType dataType, java.lang.Object defaultValue, boolean changeNotNull, boolean shouldBeNotNull)
AbstractSQLGenerator
alterTableAlterColumn
in class AbstractSQLGenerator
public void alterTableSetNotNull(SQLBatch sqls, java.lang.String table, java.lang.String column, TableColumnDataType currentDataType, java.lang.Object currentDefaultValue, boolean notNull)
alterTableSetNotNull
in class AbstractSQLGenerator
public void dropSequence(SQLBatch sqls, java.lang.String sequenceToDrop)
dropSequence
in class AbstractSQLGenerator
public void dropTable(SQLBatch sqls, java.lang.String tableToDrop)
dropTable
in class AbstractSQLGenerator
public DatabaseSchema scanDatabase(SQLConnector connector, SQLScannerFilter filter) throws PalioException
scanDatabase
in class AbstractSQLGenerator
PalioException