Class SQLServerDDLDialect

java.lang.Object

org.huiche.ddl.dialect.BaseDDLDialect

org.huiche.ddl.dialect.SQLServerDDLDialect

All Implemented Interfaces:

DDLDialect

public class SQLServerDDLDialect
extends BaseDDLDialect

SQLServer DDL方言

原生json数据类型自SQL Server 2025 (17.x)起可用,故兜底类型直接使用默认的jsonType(), 不做回退;旧版(2016-2022)仅提供JSON函数,需用nvarchar存储,不在本框架的版本基线内.

Author:

Maning

Field Summary

Fields inherited from class BaseDDLDialect

defaultTypeMapping, LOG

Constructor Summary

Constructors

Constructor	Description
SQLServerDDLDialect(SQLServerDialect delegate)	默认构造

Method Summary

Modifier and Type	Method	Description
boolean	addPrimaryKeyAddNotNull()	添加主键时,检查添加notnull
String	autoIncrementSyntaxSegment()	自增语法片段
TypeDef	blobType()	blob类型名称
TypeDef	booleanType()	boolean类型名称
TypeDef	clobType()	clob类型名称
TypeDef	intType()	int类型名称
TypeDef	timestrampType()	timestramp类型名称
TypeDef	tinyintType()	tinyint类型名称
List<String>	translate(AlterColumnComment statement)	翻译修改列注释语句
List<String>	translate(AlterColumnType statement)	翻译修改列语句
List<String>	translate(AlterDefault statement)	翻译设置默认值语句
List<String>	translate(AlterNullabe statement)	翻译新增列NOTNULL语句
List<String>	translate(AlterTableComment statement)	翻译修改表注释语句
List<String>	translate(DropPrimaryKey statement)	翻译删除主键语句
List<String>	translate(ModifyColumn statement)	翻译修改列语句
TypeDef	varcharType(int length)	varchar类型名称

Methods inherited from class BaseDDLDialect

compareColumn, compareTable, concatType, quote, resolveTable, resolveTableByJdbc, resolveType, translate, translate, translate, translate, translate, translateColumn, translatePKinCreateTable

Methods inherited from class Object

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

Methods inherited from interface DDLDialect

addUniqueAddNotNull, bigintType, charType, compareLengthOrScale, dateType, dbTypeMapping, decimalType, embeddedColumnComment, embeddedTableComment, fallbackType, jsonType, requiresExplicitNotNullForPrimaryKey, resolveEnumType, smallintType, timeType, translate

Constructor Details

SQLServerDDLDialect

public SQLServerDDLDialect(SQLServerDialect delegate)

默认构造

Parameters:

delegate - 方言代理

Method Details

addPrimaryKeyAddNotNull

public boolean addPrimaryKeyAddNotNull()

Description copied from interface: DDLDialect

添加主键时,检查添加notnull

Returns:

添加主键时,检查添加notnull

blobType

public TypeDef blobType()

Description copied from interface: DDLDialect

blob类型名称

Returns:

blob类型名称

booleanType

public TypeDef booleanType()

Description copied from interface: DDLDialect

boolean类型名称

Returns:

boolean类型名称

clobType

public TypeDef clobType()

Description copied from interface: DDLDialect

clob类型名称

Returns:

blob类型名称

intType

public TypeDef intType()

Description copied from interface: DDLDialect

int类型名称

Returns:

int类型名称

timestrampType

public TypeDef timestrampType()

Description copied from interface: DDLDialect

timestramp类型名称

Returns:

timestramp类型名称

tinyintType

public TypeDef tinyintType()

Description copied from interface: DDLDialect

tinyint类型名称

Returns:

tinyint类型名称

varcharType

public TypeDef varcharType(int length)

Description copied from interface: DDLDialect

varchar类型名称

Parameters:

length - 长度

Returns:

varchar类型名称

autoIncrementSyntaxSegment

public String autoIncrementSyntaxSegment()

Description copied from interface: DDLDialect

自增语法片段

Specified by:

autoIncrementSyntaxSegment in interface DDLDialect

Overrides:

autoIncrementSyntaxSegment in class BaseDDLDialect

Returns:

自增语法片段

translate

public List<String> translate(AlterNullabe statement)

Description copied from interface: DDLDialect

翻译新增列NOTNULL语句

Specified by:

translate in interface DDLDialect

Overrides:

translate in class BaseDDLDialect

Parameters:

statement - 语句

Returns:

翻译后的SQL

translate

public List<String> translate(AlterTableComment statement)

Description copied from interface: DDLDialect

翻译修改表注释语句

Specified by:

translate in interface DDLDialect

Overrides:

translate in class BaseDDLDialect

Parameters:

statement - 语句

Returns:

翻译后的SQL

translate

public List<String> translate(AlterColumnType statement)

Description copied from interface: DDLDialect

翻译修改列语句

Specified by:

translate in interface DDLDialect

Overrides:

translate in class BaseDDLDialect

Parameters:

statement - 语句

Returns:

翻译后的SQL

translate

public List<String> translate(AlterColumnComment statement)

Description copied from interface: DDLDialect

翻译修改列注释语句

Specified by:

translate in interface DDLDialect

Overrides:

translate in class BaseDDLDialect

Parameters:

statement - 语句

Returns:

翻译后的SQL

translate

public List<String> translate(DropPrimaryKey statement)

Description copied from interface: DDLDialect

翻译删除主键语句

Specified by:

translate in interface DDLDialect

Overrides:

translate in class BaseDDLDialect

Parameters:

statement - 语句

Returns:

翻译后的SQL

translate

public List<String> translate(ModifyColumn statement)

Description copied from interface: DDLDialect

翻译修改列语句

Specified by:

translate in interface DDLDialect

Overrides:

translate in class BaseDDLDialect

Parameters:

statement - 语句

Returns:

翻译后的SQL

translate

public List<String> translate(AlterDefault statement)

Description copied from interface: DDLDialect

翻译设置默认值语句

Specified by:

translate in interface DDLDialect

Overrides:

translate in class BaseDDLDialect

Parameters:

statement - 语句

Returns:

翻译后的SQL