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 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.

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, 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, processChanges, processTableStructureChanges, processTableStructureChanges, renameTable, restoreTableFromBackup, setCaseSensitive, setDelimitedIdentifierModeOn, setIndent, setScriptModeOn, setSqlCommentsOn, setValueDateFormat, setValueLocale, setValueNumberFormat, setValueTimeFormat, shortenName, shouldGeneratePrimaryKeys, writeAlterColumnDataTypeToBigInt, writeCascadeAttributesForForeignKey, writeCastExpression, writeColumn, writeColumnDefaultValueStmt, writeColumnEmbeddedPrimaryKey, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeColumnType, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalIndexCreate, writeExternalIndexCreateStmt, writeExternalIndexDropStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeFixLastIdentityValues, writeForeignReferences, writeIdentityGapLimit, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreationStmt, writeTableCreationStmtEnding

Methods inherited from class java.lang.Object

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

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