public class MSSQLDatabase extends AbstractJdbcDatabase
| Modifier and Type | Field and Description |
|---|---|
static String |
PRODUCT_NAME |
protected Set<String> |
systemTablesAndViews |
caseSensitive, currentDateTimeFunction, dateFunctions, defaultAutoIncrementBy, defaultAutoIncrementStartWith, defaultCatalogName, defaultSchemaName, quotingEndCharacter, quotingEndReplacement, quotingStartCharacter, quotingStrategy, sequenceCurrentValueFunction, sequenceNextValueFunction, unmodifiableDataTypes, unquotedObjectsAreUppercasedCOMPARATOR, PRIORITY_DATABASE, PRIORITY_DEFAULT| Constructor and Description |
|---|
MSSQLDatabase() |
| Modifier and Type | Method and Description |
|---|---|
String |
escapeDataTypeName(String dataTypeName) |
String |
escapeObjectName(String objectName,
Class<? extends DatabaseObject> objectType) |
String |
escapeObjectName(String catalogName,
String schemaName,
String objectName,
Class<? extends DatabaseObject> objectType) |
String |
escapeTableName(String catalogName,
String schemaName,
String tableName) |
protected boolean |
generateAutoIncrementBy(BigInteger incrementBy) |
protected boolean |
generateAutoIncrementStartWith(BigInteger startWith) |
String |
generateDefaultConstraintName(String tableName,
String columnName) |
protected String |
getAutoIncrementByClause() |
protected String |
getAutoIncrementClause() |
protected String |
getAutoIncrementStartWithClause() |
String |
getConcatSql(String... values)
Returns SQL to concat the passed values.
|
protected SqlStatement |
getConnectionSchemaNameCallStatement()
Used to obtain the connection schema name through a statement
Override this method to change the statement.
|
int |
getDataTypeMaxParameters(String dataTypeName) |
String |
getDateLiteral(String isoDate)
Return a date literal with the same value as a string formatted using ISO 8601.
|
String |
getDefaultCatalogName() |
protected String |
getDefaultDatabaseProductName() |
String |
getDefaultDriver(String url)
If this database understands the given url, return the default driver class name.
|
Integer |
getDefaultPort() |
String |
getEngineEdition() |
String |
getJdbcSchemaName(CatalogAndSchema schema) |
int |
getPriority() |
String |
getShortName()
Returns an all-lower-case short name of the product.
|
protected Set<String> |
getSystemTables()
Returns system (undroppable) views.
|
Set<String> |
getSystemViews()
Returns system (undroppable) views.
|
String |
getViewDefinition(CatalogAndSchema schema,
String viewName) |
boolean |
isAzureDb() |
boolean |
isCaseSensitive() |
boolean |
isCorrectDatabaseImplementation(DatabaseConnection conn)
Is this AbstractDatabase subclass the correct one to use for the given connection.
|
boolean |
isSystemObject(DatabaseObject example) |
boolean |
sendsStringParametersAsUnicode() |
boolean |
supportsCatalogInObjectName(Class<? extends DatabaseObject> type) |
boolean |
supportsDropTableCascadeConstraints() |
boolean |
supportsInitiallyDeferrableColumns()
Returns whether this database support initially deferrable columns.
|
boolean |
supportsRestrictForeignKeys() |
boolean |
supportsSequences()
Does the database type support sequence.
|
boolean |
supportsTablespaces() |
String |
unescapeDataTypeName(String dataTypeName) |
String |
unescapeDataTypeString(String dataTypeString) |
addReservedWords, canCreateChangeLogTable, close, commit, correctObjectName, correctSchema, correctSchema, createsIndexesForForeignKeys, dataTypeIsNotModifiable, disableForeignKeyChecks, doesTagExist, dropDatabaseObjects, enableForeignKeyChecks, equals, escapeColumnName, escapeColumnName, escapeColumnNameList, escapeConstraintName, escapeIndexName, escapeSequenceName, escapeStringForDatabase, escapeViewName, execute, executeRollbackStatements, executeRollbackStatements, executeStatements, filterRollbackVisitors, generateDatabaseFunctionValue, generatePrimaryKeyName, get, getAutoCommitMode, getAutoIncrementClause, getAutoIncrementClosing, getAutoIncrementOpening, getConnection, getConnectionCatalogName, getConnectionSchemaName, getContainingObjects, getCurrentDateTimeFunction, getDatabaseChangeLogLockTableName, getDatabaseChangeLogTableName, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDateFunctions, getDateLiteral, getDateLiteral, getDateTimeLiteral, getDefaultSchema, getDefaultSchemaName, getFetchSize, getJdbcCatalogName, getJdbcCatalogName, getJdbcSchemaName, getLineComment, getLiquibaseCatalogName, getLiquibaseSchemaName, getLiquibaseTablespaceName, getName, getObjectQuotingStrategy, getOutputDefaultCatalog, getOutputDefaultSchema, getRanChangeSet, getRanChangeSetList, getRanDate, getRunStatus, getSchemaFromJdbcInfo, getSystemSchema, getTimeLiteral, hashCode, isAutoCommit, isDateOnly, isDateTime, isDefaultCatalog, isDefaultSchema, isFunction, isLiquibaseObject, isReservedWord, isSafeToRunUpdate, isSystemView, isTimeOnly, isTimestamp, jdbcCallsCatalogsSchemas, markChangeSetExecStatus, mustQuoteObjectName, parseDate, quoteObject, removeRanStatus, requiresPassword, requiresUsername, resetInternalState, rollback, saveRollbackStatement, saveStatements, set, setAutoCommit, setCanCacheLiquibaseTableInfo, setCaseSensitive, setConnection, setCurrentDateTimeFunction, setDatabaseChangeLogLockTableName, setDatabaseChangeLogTableName, setDefaultCatalogName, setDefaultSchemaName, setLiquibaseCatalogName, setLiquibaseSchemaName, setLiquibaseTablespaceName, setObjectQuotingStrategy, setOutputDefaultCatalog, setOutputDefaultSchema, startsWithNumeric, supportsAutoIncrement, supportsCatalogs, supportsDDLInTransaction, supportsForeignKeyDisable, supportsPrimaryKeyNames, supportsSchemas, tag, toString, validatepublic static final String PRODUCT_NAME
public String getShortName()
Databasepublic int getPriority()
protected String getDefaultDatabaseProductName()
getDefaultDatabaseProductName in class AbstractJdbcDatabasepublic Integer getDefaultPort()
public Set<String> getSystemViews()
AbstractJdbcDatabasegetSystemViews in class AbstractJdbcDatabaseprotected Set<String> getSystemTables()
AbstractJdbcDatabasegetSystemTables in class AbstractJdbcDatabasepublic boolean supportsInitiallyDeferrableColumns()
Databasepublic boolean supportsSequences()
AbstractJdbcDatabasesupportsSequences in interface DatabasesupportsSequences in class AbstractJdbcDatabasepublic boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException
DatabaseDatabaseExceptionpublic String getDefaultDriver(String url)
Databaseprotected String getAutoIncrementClause()
getAutoIncrementClause in class AbstractJdbcDatabaseprotected boolean generateAutoIncrementStartWith(BigInteger startWith)
generateAutoIncrementStartWith in class AbstractJdbcDatabaseprotected boolean generateAutoIncrementBy(BigInteger incrementBy)
generateAutoIncrementBy in class AbstractJdbcDatabaseprotected String getAutoIncrementStartWithClause()
getAutoIncrementStartWithClause in class AbstractJdbcDatabaseprotected String getAutoIncrementByClause()
getAutoIncrementByClause in class AbstractJdbcDatabasepublic String getDefaultCatalogName()
getDefaultCatalogName in interface DatabasegetDefaultCatalogName in class AbstractJdbcDatabaseprotected SqlStatement getConnectionSchemaNameCallStatement()
AbstractJdbcDatabasegetConnectionSchemaNameCallStatement in class AbstractJdbcDatabaseAbstractJdbcDatabase.getConnectionSchemaName()public String getConcatSql(String... values)
DatabasegetConcatSql in interface DatabasegetConcatSql in class AbstractJdbcDatabasepublic String escapeTableName(String catalogName, String schemaName, String tableName)
escapeTableName in interface DatabaseescapeTableName in class AbstractJdbcDatabasepublic boolean supportsTablespaces()
public boolean isSystemObject(DatabaseObject example)
isSystemObject in interface DatabaseisSystemObject in class AbstractJdbcDatabasepublic String generateDefaultConstraintName(String tableName, String columnName)
public String escapeObjectName(String objectName, Class<? extends DatabaseObject> objectType)
escapeObjectName in interface DatabaseescapeObjectName in class AbstractJdbcDatabasepublic String getDateLiteral(String isoDate)
AbstractJdbcDatabasegetDateLiteral in interface DatabasegetDateLiteral in class AbstractJdbcDatabasepublic boolean supportsRestrictForeignKeys()
supportsRestrictForeignKeys in interface DatabasesupportsRestrictForeignKeys in class AbstractJdbcDatabasepublic boolean supportsDropTableCascadeConstraints()
supportsDropTableCascadeConstraints in interface DatabasesupportsDropTableCascadeConstraints in class AbstractJdbcDatabasepublic boolean supportsCatalogInObjectName(Class<? extends DatabaseObject> type)
supportsCatalogInObjectName in interface DatabasesupportsCatalogInObjectName in class AbstractJdbcDatabasepublic String getViewDefinition(CatalogAndSchema schema, String viewName) throws DatabaseException
getViewDefinition in interface DatabasegetViewDefinition in class AbstractJdbcDatabaseDatabaseExceptionpublic String escapeObjectName(String catalogName, String schemaName, String objectName, Class<? extends DatabaseObject> objectType)
escapeObjectName in interface DatabaseescapeObjectName in class AbstractJdbcDatabasepublic String getJdbcSchemaName(CatalogAndSchema schema)
getJdbcSchemaName in class AbstractJdbcDatabasepublic boolean isCaseSensitive()
isCaseSensitive in interface DatabaseisCaseSensitive in class AbstractJdbcDatabasepublic int getDataTypeMaxParameters(String dataTypeName)
getDataTypeMaxParameters in interface DatabasegetDataTypeMaxParameters in class AbstractJdbcDatabasepublic String escapeDataTypeName(String dataTypeName)
escapeDataTypeName in interface DatabaseescapeDataTypeName in class AbstractJdbcDatabasepublic String unescapeDataTypeName(String dataTypeName)
unescapeDataTypeName in interface DatabaseunescapeDataTypeName in class AbstractJdbcDatabasepublic String unescapeDataTypeString(String dataTypeString)
unescapeDataTypeString in interface DatabaseunescapeDataTypeString in class AbstractJdbcDatabasepublic boolean sendsStringParametersAsUnicode()
public boolean isAzureDb()
public String getEngineEdition()
Copyright © 2018 Liquibase.org. All rights reserved.