Package org.jumpmind.db.platform.mssql

Class MsSql2008DdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.mssql.MsSql2000DdlBuilder

org.jumpmind.db.platform.mssql.MsSql2005DdlBuilder

org.jumpmind.db.platform.mssql.MsSql2008DdlBuilder

All Implemented Interfaces:

IDdlBuilder

Direct Known Subclasses:

MsSql2016DdlBuilder

public class MsSql2008DdlBuilder
extends MsSql2005DdlBuilder

Field Summary

Fields

Modifier and Type	Field	Description
static final String	CHANGE_TRACKING_SYM_PREFIX

Fields inherited from class org.jumpmind.db.platform.mssql.MsSql2005DdlBuilder

NVARCHARMAX_LIMIT, VARCHARMAX_LIMIT

Fields inherited from class org.jumpmind.db.platform.AbstractDdlBuilder

caseSensitive, databaseInfo, databaseName, delimitedIdentifierModeOn, log, scriptModeOn, SIZE_PLACEHOLDER, sqlCommentsOn

Constructor Summary

Constructors

Constructor	Description
MsSql2008DdlBuilder()

Method Summary

Modifier and Type	Method	Description
protected boolean	hasSize(Column column)
void	initCteExpression()
String	mapDefaultValue(Object defaultValue, Column column)
protected boolean	shouldUseQuotes(String defaultValue, Column column)
protected void	writeExternalIndexCreate(Table table, IIndex index, StringBuilder ddl)
protected void	writeTableCreationStmt(Table table, StringBuilder ddl)	Writes the table creation statement without the statement end.

Methods inherited from class org.jumpmind.db.platform.mssql.MsSql2005DdlBuilder

addLobMapping, dropColumnChangeDefaults, dropDefaultConstraint, getSqlType, writeColumnType

Methods inherited from class org.jumpmind.db.platform.mssql.MsSql2000DdlBuilder

createTable, createUniqueIdentifier, dropExternalForeignKeys, dropTable, filterColumnSqlType, getDeleteSql, getInsertSql, getNativeDefaultValue, getSelectLastIdentityValues, getUpdateSql, getValueAsString, getValueDateFormat, getValueTimeFormat, printAlwaysSingleQuotedIdentifier, processChange, processChange, processChange, processChanges, processColumnChange, processTableStructureChanges, writeCascadeAttributesForForeignKeyDelete, writeCascadeAttributesForForeignKeyUpdate, writeColumnAutoIncrementStmt, writeColumnDefaultValue, writeCopyDataStatement, writeExternalForeignKeyDropStmt, writeGeneratedColumn

Methods inherited from class org.jumpmind.db.platform.AbstractDdlBuilder

addEscapedCharSequence, alterDatabase, alterDatabase, alterTable, areColumnSizesTheSame, areEqual, areMappedTypesTheSame, copy, createBackupTableFor, createExternalForeignKeys, createExternalForeignKeys, createTable, createTables, createTables, createTemporaryTable, dropTable, dropTables, dropTables, dropTemporaryTable, escapeStringValue, filterChanges, findCorrespondingForeignKey, findForeignKey, findTable, fixLastIdentityValues, getBackupTableFor, getBareNativeType, getColumnName, getColumnTypeDdl, getConstraintName, getCopyDataColumnMapping, getCopyDataColumnOrderedMapping, getDatabaseInfo, getDefaultValueHelper, getDefinitionForGeneratedColumn, getDelimitedIdentifier, getDetectedChanges, getForeignKeyName, getFullyQualifiedIndexNameShorten, getFullyQualifiedTableNameShorten, getGapLimitSize, getIndent, getIndexName, getNativeType, getRealTargetTableFor, getSize, getTableName, getTemporaryTableFor, getTemporaryTableFor, getTriggerDelimiterReplacementCharacters, getValueLocale, getValueNumberFormat, isAlterDatabase, isCaseSensitive, isDelimitedIdentifierModeOn, isFullTextIndex, isScriptModeOn, isSpecifyIdentityGapLimit, isSqlCommentsOn, isValidDefaultValue, mergeOrRemovePlatformTypes, printComment, printDefaultValue, printEndOfStatement, printIdentifier, printIndent, println, println, printlnIdentifier, printStartOfEmbeddedStatement, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChanges, processTableStructureChanges, processTableStructureChanges, renameTable, replaceDelimiterWithEscapeCharacters, restoreTableFromBackup, setCaseSensitive, setDelimitedIdentifierModeOn, setIndent, setScriptModeOn, setSqlCommentsOn, setTriggerDelimiterReplacementCharacters, setValueDateFormat, setValueLocale, setValueNumberFormat, setValueTimeFormat, shortenName, shouldGeneratePrimaryKeys, writeAlterColumnDataTypeToBigInt, writeCascadeAttributesForForeignKey, writeCastExpression, writeColumn, writeColumnAutoUpdateStmt, writeColumnDefaultValueStmt, writeColumnEmbeddedPrimaryKey, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalIndexCreateStmt, writeExternalIndexDropStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeFixLastIdentityValues, writeForeignReferences, writeIdentityGapLimit, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreateOpeningStmt, writeTableCreationStmtEnding

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

CHANGE_TRACKING_SYM_PREFIX

public static final String CHANGE_TRACKING_SYM_PREFIX

See Also:

• Constant Field Values

Constructor Details

MsSql2008DdlBuilder

public MsSql2008DdlBuilder()

Method Details

mapDefaultValue

public String mapDefaultValue(Object defaultValue,
 Column column)

Specified by:

mapDefaultValue in interface IDdlBuilder

Overrides:

mapDefaultValue in class MsSql2000DdlBuilder

shouldUseQuotes

protected boolean shouldUseQuotes(String defaultValue,
 Column column)

Overrides:

shouldUseQuotes in class MsSql2000DdlBuilder

hasSize

protected boolean hasSize(Column column)

Overrides:

hasSize in class AbstractDdlBuilder

writeExternalIndexCreate

protected void writeExternalIndexCreate(Table table,
 IIndex index,
 StringBuilder ddl)

Overrides:

writeExternalIndexCreate in class MsSql2005DdlBuilder

writeTableCreationStmt

protected void writeTableCreationStmt(Table table,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Writes the table creation statement without the statement end.

Overrides:

writeTableCreationStmt in class AbstractDdlBuilder

initCteExpression

public void initCteExpression()

Specified by:

initCteExpression in interface IDdlBuilder

Overrides:

initCteExpression in class AbstractDdlBuilder