exposed-core/org.jetbrains.exposed.v1.core.vendors/SQLServerDialect

SQLServerDialect

open class SQLServerDialect : VendorDialect

SQLServer dialect implementation.

Constructors

SQLServerDialect

constructor()

Types

Companion

object Companion : VendorDialect.DialectNameProvider

Properties

dataTypeProvider

open override val dataTypeProvider: DataTypeProvider

Data type provider of this dialect.

defaultReferenceOption

open override val defaultReferenceOption: ReferenceOption

Returns the default reference option for the dialect.

functionProvider

open override val functionProvider: FunctionProvider

Function provider of this dialect.

h2Mode

val DatabaseDialect.h2Mode: H2Dialect.H2CompatibilityMode?

The current H2 database compatibility mode or null if the current database is not H2.

likePatternSpecialChars

open override val likePatternSpecialChars: Map<Char, Char?>

Returns a mapping of dialect-specific characters to be escaped when used alongside the LIKE operator.

name

open override val name: String

Name of this dialect.

needsQuotesWhenSymbolsInNames

open override val needsQuotesWhenSymbolsInNames: Boolean = false

Returns true if the dialect requires the use of quotes when using symbols in object names, false otherwise.

needsSequenceToAutoInc

open val needsSequenceToAutoInc: Boolean

Returns true if the dialect requires the use of a sequence to create an auto-increment column, false otherwise.

requiresAutoCommitOnCreateDrop

open val requiresAutoCommitOnCreateDrop: Boolean

Returns true if autoCommit should be enabled to create/drop a database.

sequenceMaxValue

open val sequenceMaxValue: Long

Returns the allowed maximum sequence value for a dialect, as a Long.

supportsColumnTypeChange

open val supportsColumnTypeChange: Boolean

Returns whether Exposed currently supports column type change in migrations for this dialect.

supportsCreateSchema

open val supportsCreateSchema: Boolean

Returnstrue if the dialect supports schema creation.

supportsCreateSequence

open val supportsCreateSequence: Boolean

Returns true if the dialect supports the creation of sequences, false otherwise.

supportsDualTableConcept

open val supportsDualTableConcept: Boolean

Returns true if the dialect provides a special dummy DUAL table, accessible by all users.

supportsIfNotExists

open override val supportsIfNotExists: Boolean = false

Returns true if the dialect supports the IF EXISTS/IF NOT EXISTS option when creating, altering or dropping objects, false otherwise.

supportsMultipleGeneratedKeys

open override val supportsMultipleGeneratedKeys: Boolean = true

Returns true if the dialect supports returning multiple generated keys as a result of an insert operation, false otherwise.

supportsOnlyIdentifiersInGeneratedKeys

open override val supportsOnlyIdentifiersInGeneratedKeys: Boolean = true

Returns true if the dialect supports only returning generated keys that are identity columns.

supportsOnUpdate

open val supportsOnUpdate: Boolean

Returns true if the dialect supports using the ON UPDATE clause with a foreign key constraint.

supportsOrderByNullsFirstLast

open val supportsOrderByNullsFirstLast: Boolean

Returns true if the dialect provides options to configure how nulls are sorted compared to non-null values.

supportsRestrictReferenceOption

open override val supportsRestrictReferenceOption: Boolean = false

Returns true if the dialect supports the RESTRICT action as part of a foreign key constraint clause.

supportsSelectForUpdate

open val ~~supportsSelectForUpdate~~: Boolean

Returns true if the dialect supports SELECT FOR UPDATE statements, false otherwise.

supportsSequenceAsGeneratedKeys

open override val supportsSequenceAsGeneratedKeys: Boolean = false

Returns true if the dialect supports returning generated keys obtained from a sequence.

supportsSetDefaultReferenceOption

open val supportsSetDefaultReferenceOption: Boolean

Returns true if the dialect supports the SET DEFAULT action as part of a foreign key constraint clause.

supportsSubqueryUnions

open val supportsSubqueryUnions: Boolean

Returns true if the dialect supports subqueries within a UNION/EXCEPT/INTERSECT statement.

supportsTernaryAffectedRowValues

open val supportsTernaryAffectedRowValues: Boolean

Returns true if the dialect supports an upsert operation returning an affected-row value of 0, 1, or 2.

supportsWindowFrameGroupsMode

open val supportsWindowFrameGroupsMode: Boolean

Returns true if the dialect supports window function definitions with GROUPS mode in frame clause

Functions

addPrimaryKey

open override fun addPrimaryKey(table: Table, pkName: String?, vararg pkColumns: Column<*>): String

Returns the SQL statement that adds a primary key specified pkName to an existing table.

areEquivalentColumnTypes

open fun ~~areEquivalentColumnTypes~~(columnMetadataSqlType: String, columnMetadataJdbcType: Int, columnType: String): Boolean

Returns whether the columnMetadataSqlType type and the columnType are equivalent.

createDatabase

open override fun createDatabase(name: String): String

Returns the SQL statement that creates a database with the specified name.

createIndex

open override fun createIndex(index: Index): String

Uniqueness might be required for foreign key constraints.

createSchema

open override fun createSchema(schema: Schema): String

Returns the SQL statement that creates the specified schema.

dropDatabase

open override fun dropDatabase(name: String): String

Returns the SQL statement that drops the database with the specified name.

dropIndex

open override fun dropIndex(tableName: String, indexName: String, isUnique: Boolean, isPartialOrFunctional: Boolean): String

Returns the SQL statement that drops the specified indexName from the specified tableName.

dropSchema

open override fun dropSchema(schema: Schema, cascade: Boolean): String

Returns the SQL statement that drops the specified schema, as well as all its objects if cascade is true.

filterCondition

fun filterCondition(index: Index): String?

isAllowedAsColumnDefault

open override fun isAllowedAsColumnDefault(e: Expression<*>): Boolean

Returns true if the specified e is allowed as a default column value in the dialect, false otherwise.

listDatabases

open override fun listDatabases(): String

Returns the SQL query that retrieves a set of existing databases.

modifyColumn

open override fun modifyColumn(column: Column<*>, columnDiff: ColumnDiff): List<String>

Returns the SQL statement that modifies the specified column.

setSchema

open override fun setSchema(schema: Schema): String

Returns the SQL statement that sets the current schema to the specified schema.