Package org.jumpmind.db.platform.mssql

Class MsSql2005DdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.mssql.MsSql2000DdlBuilder

org.jumpmind.db.platform.mssql.MsSql2005DdlBuilder

All Implemented Interfaces:

IDdlBuilder

Direct Known Subclasses:

MsSql2008DdlBuilder

public class MsSql2005DdlBuilder
extends MsSql2000DdlBuilder

Field Summary

Fields

Modifier and Type	Field	Description
static final int	NVARCHARMAX_LIMIT
static final int	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
MsSql2005DdlBuilder()

Method Summary

Modifier and Type	Method	Description
protected void	addLobMapping()
protected void	dropColumnChangeDefaults(Table sourceTable, Column sourceColumn, StringBuilder ddl)
protected void	dropDefaultConstraint(Table table, String columnName, StringBuilder ddl)
String	getSqlType(Column column)	Returns the full SQL type specification (including size and precision/scale) for the given column.
protected void	writeColumnType(Table table, Column column, StringBuilder ddl)
protected void	writeExternalIndexCreate(Table table, IIndex index, StringBuilder ddl)

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

createTable, createUniqueIdentifier, dropExternalForeignKeys, dropTable, filterColumnSqlType, getDeleteSql, getInsertSql, getNativeDefaultValue, getSelectLastIdentityValues, getUpdateSql, getValueAsString, getValueDateFormat, getValueTimeFormat, mapDefaultValue, printAlwaysSingleQuotedIdentifier, processChange, processChange, processChange, processChanges, processColumnChange, processTableStructureChanges, shouldUseQuotes, 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, hasSize, initCteExpression, 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, writeTableCreationStmt, writeTableCreationStmtEnding

Methods inherited from class java.lang.Object

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

Field Details

NVARCHARMAX_LIMIT

public static final int NVARCHARMAX_LIMIT

See Also:

• Constant Field Values

VARCHARMAX_LIMIT

public static final int VARCHARMAX_LIMIT

See Also:

• Constant Field Values

Constructor Details

MsSql2005DdlBuilder

public MsSql2005DdlBuilder()

Method Details

addLobMapping

protected void addLobMapping()

Overrides:

addLobMapping in class MsSql2000DdlBuilder

dropDefaultConstraint

protected void dropDefaultConstraint(Table table,
 String columnName,
 StringBuilder ddl)

Overrides:

dropDefaultConstraint in class MsSql2000DdlBuilder

dropColumnChangeDefaults

protected void dropColumnChangeDefaults(Table sourceTable,
 Column sourceColumn,
 StringBuilder ddl)

Overrides:

dropColumnChangeDefaults in class MsSql2000DdlBuilder

getSqlType

public String getSqlType(Column column)

Description copied from class: AbstractDdlBuilder

Returns the full SQL type specification (including size and precision/scale) for the given column.

Specified by:

getSqlType in interface IDdlBuilder

Overrides:

getSqlType in class AbstractDdlBuilder

Parameters:

column - The column

Returns:

The full SQL type string including the size

writeColumnType

protected void writeColumnType(Table table,
 Column column,
 StringBuilder ddl)

Overrides:

writeColumnType in class AbstractDdlBuilder

writeExternalIndexCreate

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

Overrides:

writeExternalIndexCreate in class AbstractDdlBuilder