Liquibase 4.26.0 · liquibase.database.core.MSSQLDatabase

Modifier and Type	Class and Description
public static class	MSSQLDatabase.MSSQL_SERVER_VERSIONS

Modifier and Type	Field and Description
private static final Pattern	CREATE_VIEW_AS_PATTERN Hides liquibase.database.AbstractJdbcDatabase.CREATE_VIEW_AS_PATTERN.
private final HashMap<String, Integer>	defaultDataTypeParameters
protected static final int	MSSQL_DEFAULT_TCP_PORT
public static final String	PRODUCT_NAME
private Boolean	sendsStringParametersAsUnicode
protected Set<String>	systemTablesAndViews

Access	Constructor and Description
public	MSSQLDatabase()

Modifier and Type	Method and Description
private List<SqlVisitor>	addSqlVisitors(List<SqlVisitor> sqlVisitors)
private static List<String>	createReservedWordsCollection()
public String	escapeDataTypeName(String dataTypeName) Overrides liquibase.database.AbstractJdbcDatabase.escapeDataTypeName. Implements liquibase.database.Database.escapeDataTypeName.
public String	escapeObjectName(String objectName, Class<? extends DatabaseObject> objectType) Overrides liquibase.database.AbstractJdbcDatabase.escapeObjectName. Implements liquibase.database.Database.escapeObjectName.
public String	escapeObjectName(String catalogName, String schemaName, String objectName, Class<? extends DatabaseObject> objectType) Overrides liquibase.database.AbstractJdbcDatabase.escapeObjectName. Implements liquibase.database.Database.escapeObjectName.
public String	escapeTableName(String catalogName, String schemaName, String tableName) Overrides liquibase.database.AbstractJdbcDatabase.escapeTableName. Implements liquibase.database.Database.escapeTableName.
public void	executeStatements(Change change, DatabaseChangeLog changeLog, List<SqlVisitor> sqlVisitors) Overrides liquibase.database.AbstractJdbcDatabase.executeStatements. Implements liquibase.database.Database.executeStatements.
protected boolean	generateAutoIncrementBy(BigInteger incrementBy) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy.
protected boolean	generateAutoIncrementStartWith(BigInteger startWith) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith.
public String	generateDefaultConstraintName(String tableName, String columnName)
protected String	getAutoIncrementByClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementByClause.
protected String	getAutoIncrementClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.
protected String	getAutoIncrementStartWithClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementStartWithClause.
public String	getConcatSql(String... values) Overrides liquibase.database.AbstractJdbcDatabase.getConcatSql. Implements liquibase.database.Database.getConcatSql. Returns SQL to concat the passed values.
protected SqlStatement	getConnectionSchemaNameCallStatement() Overrides liquibase.database.AbstractJdbcDatabase.getConnectionSchemaNameCallStatement. Used to obtain the connection schema name through a statement Override this method to change the statement.
public int	getDataTypeMaxParameters(String dataTypeName) Overrides liquibase.database.AbstractJdbcDatabase.getDataTypeMaxParameters. Implements liquibase.database.Database.getDataTypeMaxParameters.
public String	getDateLiteral(String isoDate) Overrides liquibase.database.AbstractJdbcDatabase.getDateLiteral. Implements liquibase.database.Database.getDateLiteral. Return a date literal with the same value as a string formatted using ISO 8601.
public String	getDefaultCatalogName() Overrides liquibase.database.AbstractJdbcDatabase.getDefaultCatalogName. Implements liquibase.database.Database.getDefaultCatalogName.
protected String	getDefaultDatabaseProductName() Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.
public String	getDefaultDriver(String url) Implements liquibase.database.Database.getDefaultDriver. If this database understands the given url, return the default driver class name.
public int	getDefaultFractionalDigitsForTimestamp() Overrides liquibase.database.AbstractJdbcDatabase.getDefaultFractionalDigitsForTimestamp. Implements liquibase.database.Database.getDefaultFractionalDigitsForTimestamp. SQL Standard (Foundation) says: "...if <timestamp precision> is not specified, then 6 is implicit."
public Integer	getDefaultPort() Implements liquibase.database.Database.getDefaultPort.
public Integer	getDefaultScaleForNativeDataType(String the name of the native data type (case-insensitive). nativeDataType) Overrides liquibase.database.AbstractJdbcDatabase.getDefaultScaleForNativeDataType. Implements liquibase.database.Database.getDefaultScaleForNativeDataType. Returns the default precision for a given native data type, e.g. "datetime2" for Microsoft SQL Server.
public String	Returns: one of the strings above getEngineEdition() Determines the capabilities ("Edition") of the SQL Server database.
public String	getJdbcSchemaName(CatalogAndSchema schema) Overrides liquibase.database.AbstractJdbcDatabase.getJdbcSchemaName.
public int	getPriority() Implements liquibase.servicelocator.PrioritizedService.getPriority.
protected String	getQuotingEndCharacter() Overrides liquibase.database.AbstractJdbcDatabase.getQuotingEndCharacter.
protected String	getQuotingEndReplacement() Overrides liquibase.database.AbstractJdbcDatabase.getQuotingEndReplacement.
protected String	getQuotingStartCharacter() Overrides liquibase.database.AbstractJdbcDatabase.getQuotingStartCharacter.
public String	getShortName() Implements liquibase.database.Database.getShortName. Returns an all-lower-case short name of the product.
protected Set<String>	getSystemTables() Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables. Returns system (undroppable) views.
public Set<String>	getSystemViews() Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews. Returns system (undroppable) views.
public String	getViewDefinition(CatalogAndSchema schema, String viewName) Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition. Implements liquibase.database.Database.getViewDefinition.
public boolean	Returns: true if instance runs in Microsoft Azure, false otherwise isAzureDb() Returns true if the connected MS SQL instance is a Microsoft Cloud ("Azure")-hosted instance of MSSQL.
public boolean	isCaseSensitive() Overrides liquibase.database.AbstractJdbcDatabase.isCaseSensitive. Implements liquibase.database.Database.isCaseSensitive.
public boolean	isCorrectDatabaseImplementation(DatabaseConnection conn) Implements liquibase.database.Database.isCorrectDatabaseImplementation. Is this AbstractDatabase subclass the correct one to use for the given connection.
public boolean	isSystemObject(DatabaseObject example) Overrides liquibase.database.AbstractJdbcDatabase.isSystemObject. Implements liquibase.database.Database.isSystemObject.
public boolean	Returns: true if the SQL Server instance uses Unicode types by default, false if not. sendsStringParametersAsUnicode() Determines if the SQL Server instance assigns Unicode data types (e.g. nvarchar) to strings.
public void	setDefaultSchemaName(String schemaName) Overrides liquibase.database.AbstractJdbcDatabase.setDefaultSchemaName. Implements liquibase.database.Database.setDefaultSchemaName.
public boolean	supportsCatalogInObjectName(Class<? extends DatabaseObject> type) Overrides liquibase.database.AbstractJdbcDatabase.supportsCatalogInObjectName. Implements liquibase.database.Database.supportsCatalogInObjectName.
public boolean	supportsDropTableCascadeConstraints() Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints. Implements liquibase.database.Database.supportsDropTableCascadeConstraints.
public boolean	supportsInitiallyDeferrableColumns() Implements liquibase.database.Database.supportsInitiallyDeferrableColumns. Returns whether this database support initially deferrable columns.
public boolean	supportsRestrictForeignKeys() Overrides liquibase.database.AbstractJdbcDatabase.supportsRestrictForeignKeys. Implements liquibase.database.Database.supportsRestrictForeignKeys.
public boolean	supportsSequences() Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences. Implements liquibase.database.Database.supportsSequences. Does the database type support sequence.
public boolean	supportsTablespaces() Implements liquibase.database.Database.supportsTablespaces.
public String	unescapeDataTypeName(String dataTypeName) Overrides liquibase.database.AbstractJdbcDatabase.unescapeDataTypeName. Implements liquibase.database.Database.unescapeDataTypeName.
public String	unescapeDataTypeString(String dataTypeString) Overrides liquibase.database.AbstractJdbcDatabase.unescapeDataTypeString. Implements liquibase.database.Database.unescapeDataTypeString.

CREATE_VIEW_AS_PATTERN	back to summary
private static final Pattern CREATE_VIEW_AS_PATTERN Hides liquibase.database.AbstractJdbcDatabase.CREATE_VIEW_AS_PATTERN.

defaultDataTypeParameters	back to summary
private final HashMap<String, Integer> defaultDataTypeParameters

MSSQL_DEFAULT_TCP_PORT	back to summary
protected static final int MSSQL_DEFAULT_TCP_PORT

PRODUCT_NAME	back to summary
public static final String PRODUCT_NAME

sendsStringParametersAsUnicode	back to summary
private Boolean sendsStringParametersAsUnicode

systemTablesAndViews	back to summary
protected Set<String> systemTablesAndViews

MSSQLDatabase	back to summary
public MSSQLDatabase() Annotations @SuppressWarnings:squid:S109

Method Detail

addSqlVisitors	back to summary
private List<SqlVisitor> addSqlVisitors(List<SqlVisitor> sqlVisitors)

createReservedWordsCollection	back to summary
private static List<String> createReservedWordsCollection()

escapeDataTypeName	back to summary
public String escapeDataTypeName(String dataTypeName) Overrides liquibase.database.AbstractJdbcDatabase.escapeDataTypeName. Implements liquibase.database.Database.escapeDataTypeName. Annotations @Override

escapeDataTypeName

back to summary

public String escapeDataTypeName(String dataTypeName)

Overrides liquibase.database.AbstractJdbcDatabase.escapeDataTypeName.

Implements liquibase.database.Database.escapeDataTypeName.

Annotations

@Override

escapeObjectName	back to summary
public String escapeObjectName(String objectName, Class<? extends DatabaseObject> objectType) Overrides liquibase.database.AbstractJdbcDatabase.escapeObjectName. Implements liquibase.database.Database.escapeObjectName. Annotations @Override

escapeObjectName

back to summary

public String escapeObjectName(String objectName, Class<? extends DatabaseObject> objectType)

Overrides liquibase.database.AbstractJdbcDatabase.escapeObjectName.

Implements liquibase.database.Database.escapeObjectName.

Annotations

@Override

escapeObjectName	back to summary
public String escapeObjectName(String catalogName, String schemaName, String objectName, Class<? extends DatabaseObject> objectType) Overrides liquibase.database.AbstractJdbcDatabase.escapeObjectName. Implements liquibase.database.Database.escapeObjectName. Annotations @Override

escapeObjectName

back to summary

public String escapeObjectName(String catalogName, String schemaName, String objectName, Class<? extends DatabaseObject> objectType)

Overrides liquibase.database.AbstractJdbcDatabase.escapeObjectName.

Implements liquibase.database.Database.escapeObjectName.

Annotations

@Override

escapeTableName	back to summary
public String escapeTableName(String catalogName, String schemaName, String tableName) Overrides liquibase.database.AbstractJdbcDatabase.escapeTableName. Implements liquibase.database.Database.escapeTableName. Annotations @Override

escapeTableName

back to summary

public String escapeTableName(String catalogName, String schemaName, String tableName)

Overrides liquibase.database.AbstractJdbcDatabase.escapeTableName.

Implements liquibase.database.Database.escapeTableName.

Annotations

@Override

executeStatements	back to summary
public void executeStatements(Change change, DatabaseChangeLog changeLog, List<SqlVisitor> sqlVisitors) throws LiquibaseException Overrides liquibase.database.AbstractJdbcDatabase.executeStatements. Implements liquibase.database.Database.executeStatements. Annotations @Override

executeStatements

back to summary

public void executeStatements(Change change, DatabaseChangeLog changeLog, List<SqlVisitor> sqlVisitors) throws LiquibaseException

Overrides liquibase.database.AbstractJdbcDatabase.executeStatements.

Implements liquibase.database.Database.executeStatements.

Annotations

@Override

generateAutoIncrementBy	back to summary
protected boolean generateAutoIncrementBy(BigInteger incrementBy) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy. Annotations @Override

generateAutoIncrementBy

back to summary

protected boolean generateAutoIncrementBy(BigInteger incrementBy)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy.

Annotations

@Override

generateAutoIncrementStartWith	back to summary
protected boolean generateAutoIncrementStartWith(BigInteger startWith) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith. Annotations @Override

generateAutoIncrementStartWith

back to summary

protected boolean generateAutoIncrementStartWith(BigInteger startWith)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith.

Annotations

@Override

generateDefaultConstraintName	back to summary
public String generateDefaultConstraintName(String tableName, String columnName)

getAutoIncrementByClause	back to summary
protected String getAutoIncrementByClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementByClause. Annotations @Override

getAutoIncrementByClause

back to summary

protected String getAutoIncrementByClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementByClause.

Annotations

@Override

getAutoIncrementClause	back to summary
protected String getAutoIncrementClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause. Annotations @Override

getAutoIncrementClause

back to summary

protected String getAutoIncrementClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.

Annotations

@Override

getAutoIncrementStartWithClause	back to summary
protected String getAutoIncrementStartWithClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementStartWithClause. Annotations @Override

getAutoIncrementStartWithClause

back to summary

protected String getAutoIncrementStartWithClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementStartWithClause.

Annotations

@Override

getConcatSql	back to summary
public String getConcatSql(String... values) Overrides liquibase.database.AbstractJdbcDatabase.getConcatSql. Implements liquibase.database.Database.getConcatSql. Doc from liquibase.database.Database.getConcatSql. Returns SQL to concat the passed values. Annotations @Override

getConcatSql

back to summary

public String getConcatSql(String... values)

Overrides liquibase.database.AbstractJdbcDatabase.getConcatSql.

Implements liquibase.database.Database.getConcatSql.

Doc from liquibase.database.Database.getConcatSql.

Returns SQL to concat the passed values.

Annotations

@Override

getConnectionSchemaNameCallStatement	back to summary
protected SqlStatement getConnectionSchemaNameCallStatement() Overrides liquibase.database.AbstractJdbcDatabase.getConnectionSchemaNameCallStatement. Doc from liquibase.database.AbstractJdbcDatabase.getConnectionSchemaNameCallStatement. Used to obtain the connection schema name through a statement Override this method to change the statement. Only override this if getConnectionSchemaName is left unchanged or is using this method. Annotations @Override

getConnectionSchemaNameCallStatement

back to summary

protected SqlStatement getConnectionSchemaNameCallStatement()

Overrides liquibase.database.AbstractJdbcDatabase.getConnectionSchemaNameCallStatement.

Doc from liquibase.database.AbstractJdbcDatabase.getConnectionSchemaNameCallStatement.

Used to obtain the connection schema name through a statement Override this method to change the statement. Only override this if getConnectionSchemaName is left unchanged or is using this method.

Annotations

@Override

getDataTypeMaxParameters	back to summary
public int getDataTypeMaxParameters(String dataTypeName) Overrides liquibase.database.AbstractJdbcDatabase.getDataTypeMaxParameters. Implements liquibase.database.Database.getDataTypeMaxParameters. Annotations @Override

getDataTypeMaxParameters

back to summary

public int getDataTypeMaxParameters(String dataTypeName)

Overrides liquibase.database.AbstractJdbcDatabase.getDataTypeMaxParameters.

Implements liquibase.database.Database.getDataTypeMaxParameters.

Annotations

@Override

getDateLiteral	back to summary
public String getDateLiteral(String isoDate) Overrides liquibase.database.AbstractJdbcDatabase.getDateLiteral. Implements liquibase.database.Database.getDateLiteral. Doc from liquibase.database.AbstractJdbcDatabase.getDateLiteral. Return a date literal with the same value as a string formatted using ISO 8601. Note many databases accept date literals in ISO8601 format with the 'T' replaced with a space. Only databases which do not accept these strings should need to override this method. Implementation restriction: Currently, only the following subsets of ISO8601 are supported: yyyy-MM-dd hh:mm:ss yyyy-MM-ddThh:mm:ss Annotations @Override

getDateLiteral

back to summary

public String getDateLiteral(String isoDate)

Overrides liquibase.database.AbstractJdbcDatabase.getDateLiteral.

Implements liquibase.database.Database.getDateLiteral.

Doc from liquibase.database.AbstractJdbcDatabase.getDateLiteral.

Return a date literal with the same value as a string formatted using ISO 8601.

Note

many databases accept date literals in ISO8601 format with the 'T' replaced with a space. Only databases which do not accept these strings should need to override this method.

Implementation restriction: Currently, only the following subsets of ISO8601 are supported: yyyy-MM-dd hh:mm:ss yyyy-MM-ddThh:mm:ss

Annotations

@Override

getDefaultCatalogName	back to summary
public String getDefaultCatalogName() Overrides liquibase.database.AbstractJdbcDatabase.getDefaultCatalogName. Implements liquibase.database.Database.getDefaultCatalogName. Annotations @Override

getDefaultCatalogName

back to summary

public String getDefaultCatalogName()

Overrides liquibase.database.AbstractJdbcDatabase.getDefaultCatalogName.

Implements liquibase.database.Database.getDefaultCatalogName.

Annotations

@Override

getDefaultDatabaseProductName	back to summary
protected String getDefaultDatabaseProductName() Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName. Annotations @Override

getDefaultDatabaseProductName

back to summary

protected String getDefaultDatabaseProductName()

Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.

Annotations

@Override

getDefaultDriver	back to summary
public String getDefaultDriver(String url) Implements liquibase.database.Database.getDefaultDriver. Doc from liquibase.database.Database.getDefaultDriver. If this database understands the given url, return the default driver class name. Otherwise return null. Annotations @Override

getDefaultDriver

back to summary

public String getDefaultDriver(String url)

Implements liquibase.database.Database.getDefaultDriver.

Doc from liquibase.database.Database.getDefaultDriver.

If this database understands the given url, return the default driver class name. Otherwise return null.

Annotations

@Override

getDefaultFractionalDigitsForTimestamp	back to summary
public int getDefaultFractionalDigitsForTimestamp() Overrides liquibase.database.AbstractJdbcDatabase.getDefaultFractionalDigitsForTimestamp. Implements liquibase.database.Database.getDefaultFractionalDigitsForTimestamp. Doc from liquibase.database.AbstractJdbcDatabase.getDefaultFractionalDigitsForTimestamp. SQL Standard (Foundation) says: "...if is not specified, then 6 is implicit." Returns:int the default precision / number of maximum digits in a timestamp if nothing else is specified. Annotations @Override

getDefaultFractionalDigitsForTimestamp

back to summary

public int getDefaultFractionalDigitsForTimestamp()

Overrides liquibase.database.AbstractJdbcDatabase.getDefaultFractionalDigitsForTimestamp.

Implements liquibase.database.Database.getDefaultFractionalDigitsForTimestamp.

Doc from liquibase.database.AbstractJdbcDatabase.getDefaultFractionalDigitsForTimestamp.

SQL Standard (Foundation) says: "...if is not specified, then 6 is implicit."

Returns:int

the default precision / number of maximum digits in a timestamp if nothing else is specified.

Annotations

@Override

getDefaultPort	back to summary
public Integer getDefaultPort() Implements liquibase.database.Database.getDefaultPort. Annotations @Override

getDefaultPort

back to summary

public Integer getDefaultPort()

Implements liquibase.database.Database.getDefaultPort.

Annotations

@Override

getDefaultScaleForNativeDataType	back to summary
public Integer getDefaultScaleForNativeDataType(String nativeDataType) Overrides liquibase.database.AbstractJdbcDatabase.getDefaultScaleForNativeDataType. Implements liquibase.database.Database.getDefaultScaleForNativeDataType. Doc from liquibase.database.Database.getDefaultScaleForNativeDataType. Returns the default precision for a given native data type, e.g. "datetime2" for Microsoft SQL Server. Parameters nativeDataType:String the name of the native data type (case-insensitive). Returns:Integer The default precision of the native data type, or null if the type is unknown to this database. Annotations @Override

getDefaultScaleForNativeDataType

back to summary

public Integer getDefaultScaleForNativeDataType(String nativeDataType)

Overrides liquibase.database.AbstractJdbcDatabase.getDefaultScaleForNativeDataType.

Implements liquibase.database.Database.getDefaultScaleForNativeDataType.

Doc from liquibase.database.Database.getDefaultScaleForNativeDataType.

Returns the default precision for a given native data type, e.g. "datetime2" for Microsoft SQL Server.

Parameters

nativeDataType:String: the name of the native data type (case-insensitive).

Returns:Integer

The default precision of the native data type, or null if the type is unknown to this database.

Annotations

@Override

getEngineEdition	back to summary
public String getEngineEdition() Determines the capabilities ("Edition") of the SQL Server database. Possible values are currently "Personal", "Standard", "Enterprise" (Developer Edition is also reported as Enterprise), "Express" or "Azure". Returns:String one of the strings above

getEngineEdition

back to summary

public String getEngineEdition()

Determines the capabilities ("Edition") of the SQL Server database. Possible values are currently "Personal", "Standard", "Enterprise" (Developer Edition is also reported as Enterprise), "Express" or "Azure".

Returns:String: one of the strings above

getJdbcSchemaName	back to summary
public String getJdbcSchemaName(CatalogAndSchema schema) Overrides liquibase.database.AbstractJdbcDatabase.getJdbcSchemaName. Annotations @Override

getJdbcSchemaName

back to summary

public String getJdbcSchemaName(CatalogAndSchema schema)

Overrides liquibase.database.AbstractJdbcDatabase.getJdbcSchemaName.

Annotations

@Override

getPriority	back to summary
public int getPriority() Implements liquibase.servicelocator.PrioritizedService.getPriority. Annotations @Override

getPriority

back to summary

public int getPriority()

Implements liquibase.servicelocator.PrioritizedService.getPriority.

Annotations

@Override

getQuotingEndCharacter	back to summary
protected String getQuotingEndCharacter() Overrides liquibase.database.AbstractJdbcDatabase.getQuotingEndCharacter. Annotations @Override

getQuotingEndCharacter

back to summary

protected String getQuotingEndCharacter()

Overrides liquibase.database.AbstractJdbcDatabase.getQuotingEndCharacter.

Annotations

@Override

getQuotingEndReplacement	back to summary
protected String getQuotingEndReplacement() Overrides liquibase.database.AbstractJdbcDatabase.getQuotingEndReplacement. Annotations @Override

getQuotingEndReplacement

back to summary

protected String getQuotingEndReplacement()

Overrides liquibase.database.AbstractJdbcDatabase.getQuotingEndReplacement.

Annotations

@Override

getQuotingStartCharacter	back to summary
protected String getQuotingStartCharacter() Overrides liquibase.database.AbstractJdbcDatabase.getQuotingStartCharacter. Annotations @Override

getQuotingStartCharacter

back to summary

protected String getQuotingStartCharacter()

Overrides liquibase.database.AbstractJdbcDatabase.getQuotingStartCharacter.

Annotations

@Override

getShortName	back to summary
public String getShortName() Implements liquibase.database.Database.getShortName. Doc from liquibase.database.Database.getShortName. Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition. Annotations @Override

getShortName

back to summary

public String getShortName()

Implements liquibase.database.Database.getShortName.

Doc from liquibase.database.Database.getShortName.

Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition.

Annotations

@Override

getSystemTables	back to summary
protected Set<String> getSystemTables() Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables. Doc from liquibase.database.AbstractJdbcDatabase.getSystemTables. Returns system (undroppable) views. Annotations @Override

getSystemTables

back to summary

protected Set<String> getSystemTables()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables.

Doc from liquibase.database.AbstractJdbcDatabase.getSystemTables.

Returns system (undroppable) views.

Annotations

@Override

getSystemViews	back to summary
public Set<String> getSystemViews() Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews. Doc from liquibase.database.AbstractJdbcDatabase.getSystemViews. Returns system (undroppable) views. Annotations @Override

getSystemViews

back to summary

public Set<String> getSystemViews()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews.

Doc from liquibase.database.AbstractJdbcDatabase.getSystemViews.

Returns system (undroppable) views.

Annotations

@Override

getViewDefinition	back to summary
public String getViewDefinition(CatalogAndSchema schema, String viewName) throws DatabaseException Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition. Implements liquibase.database.Database.getViewDefinition. Annotations @Override

getViewDefinition

back to summary

public String getViewDefinition(CatalogAndSchema schema, String viewName) throws DatabaseException

Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition.

Implements liquibase.database.Database.getViewDefinition.

Annotations

@Override

isAzureDb	back to summary
public boolean isAzureDb() Returns true if the connected MS SQL instance is a Microsoft Cloud ("Azure")-hosted instance of MSSQL. Returns:boolean true if instance runs in Microsoft Azure, false otherwise

isAzureDb

back to summary

public boolean isAzureDb()

Returns true if the connected MS SQL instance is a Microsoft Cloud ("Azure")-hosted instance of MSSQL.

Returns:boolean: true if instance runs in Microsoft Azure, false otherwise

isCaseSensitive	back to summary
public boolean isCaseSensitive() Overrides liquibase.database.AbstractJdbcDatabase.isCaseSensitive. Implements liquibase.database.Database.isCaseSensitive. Annotations @Override

isCaseSensitive

back to summary

public boolean isCaseSensitive()

Overrides liquibase.database.AbstractJdbcDatabase.isCaseSensitive.

Implements liquibase.database.Database.isCaseSensitive.

Annotations

@Override

isCorrectDatabaseImplementation	back to summary
public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException Implements liquibase.database.Database.isCorrectDatabaseImplementation. Doc from liquibase.database.Database.isCorrectDatabaseImplementation. Is this AbstractDatabase subclass the correct one to use for the given connection. Annotations @Override

isCorrectDatabaseImplementation

back to summary

public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException

Implements liquibase.database.Database.isCorrectDatabaseImplementation.

Doc from liquibase.database.Database.isCorrectDatabaseImplementation.

Is this AbstractDatabase subclass the correct one to use for the given connection.

Annotations

@Override

isSystemObject	back to summary
public boolean isSystemObject(DatabaseObject example) Overrides liquibase.database.AbstractJdbcDatabase.isSystemObject. Implements liquibase.database.Database.isSystemObject. Annotations @Override

isSystemObject

back to summary

public boolean isSystemObject(DatabaseObject example)

Overrides liquibase.database.AbstractJdbcDatabase.isSystemObject.

Implements liquibase.database.Database.isSystemObject.

Annotations

@Override

sendsStringParametersAsUnicode	back to summary
public boolean sendsStringParametersAsUnicode() Determines if the SQL Server instance assigns Unicode data types (e.g. nvarchar) to strings. Returns:boolean true if the SQL Server instance uses Unicode types by default, false if not.

sendsStringParametersAsUnicode

back to summary

public boolean sendsStringParametersAsUnicode()

Determines if the SQL Server instance assigns Unicode data types (e.g. nvarchar) to strings.

Returns:boolean: true if the SQL Server instance uses Unicode types by default, false if not.

setDefaultSchemaName	back to summary
public void setDefaultSchemaName(String schemaName) Overrides liquibase.database.AbstractJdbcDatabase.setDefaultSchemaName. Implements liquibase.database.Database.setDefaultSchemaName. Annotations @Override

setDefaultSchemaName

back to summary

public void setDefaultSchemaName(String schemaName)

Overrides liquibase.database.AbstractJdbcDatabase.setDefaultSchemaName.

Implements liquibase.database.Database.setDefaultSchemaName.

Annotations

@Override

supportsCatalogInObjectName

back to summary

public boolean supportsCatalogInObjectName(Class<? extends DatabaseObject> type)

Overrides liquibase.database.AbstractJdbcDatabase.supportsCatalogInObjectName.

Implements liquibase.database.Database.supportsCatalogInObjectName.

Annotations

@Override

supportsDropTableCascadeConstraints

back to summary

public boolean supportsDropTableCascadeConstraints()

Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints.

Implements liquibase.database.Database.supportsDropTableCascadeConstraints.

Annotations

@Override

supportsInitiallyDeferrableColumns

back to summary

public boolean supportsInitiallyDeferrableColumns()

Implements liquibase.database.Database.supportsInitiallyDeferrableColumns.

Doc from liquibase.database.Database.supportsInitiallyDeferrableColumns.

Returns whether this database support initially deferrable columns.

Annotations

@Override

supportsRestrictForeignKeys

back to summary

public boolean supportsRestrictForeignKeys()

Overrides liquibase.database.AbstractJdbcDatabase.supportsRestrictForeignKeys.

Implements liquibase.database.Database.supportsRestrictForeignKeys.

Annotations

@Override

supportsSequences

back to summary

public boolean supportsSequences()

Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences.

Implements liquibase.database.Database.supportsSequences.

Doc from liquibase.database.AbstractJdbcDatabase.supportsSequences.

Does the database type support sequence.

Annotations

@Override

supportsTablespaces

back to summary

public boolean supportsTablespaces()

Implements liquibase.database.Database.supportsTablespaces.

Annotations

@Override

unescapeDataTypeName

back to summary

public String unescapeDataTypeName(String dataTypeName)

Overrides liquibase.database.AbstractJdbcDatabase.unescapeDataTypeName.

Implements liquibase.database.Database.unescapeDataTypeName.

Annotations

@Override

unescapeDataTypeString

back to summary

public String unescapeDataTypeString(String dataTypeString)

Overrides liquibase.database.AbstractJdbcDatabase.unescapeDataTypeString.

Implements liquibase.database.Database.unescapeDataTypeString.

Annotations

@Override

Modifier and Type	Field and Description
public static final int	MSSQL2008
public static final int	MSSQL2012
public static final int	MSSQL2014
public static final int	MSSQL2016
public static final int	MSSQL2017

public Class MSSQLDatabase

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public final Class MSSQLDatabase.MSSQL_SERVER_VERSIONS

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail