SQLCreateTableStatement (druid 1.2.6.2 API)

java.lang.Object
- com.shulie.druid.sql.ast.SQLObjectImpl
- - com.shulie.druid.sql.ast.SQLStatementImpl
  - - com.shulie.druid.sql.ast.statement.SQLCreateTableStatement

所有已实现的接口:

SQLDbTypedObject, SQLObject, SQLStatement, SQLCreateStatement, SQLDDLStatement

直接已知子类:

AntsparkCreateTableStatement, BlinkCreateTableStatement, ClickhouseCreateTableStatement, DB2CreateTableStatement, HiveCreateTableStatement, MySqlCreateTableStatement, OracleCreateTableStatement
```
public class SQLCreateTableStatement
extends SQLStatementImpl
implements SQLDDLStatement, SQLCreateStatement
```

嵌套类概要

嵌套类
限定符和类型类和说明

static class SQLCreateTableStatement.Type

嵌套类
限定符和类型	类和说明
`static class`	`SQLCreateTableStatement.Type`

字段概要

字段
限定符和类型	字段和说明
`protected int`	`buckets`
`protected List<SQLSelectOrderByItem>`	`clusteredBy`
`protected ClusteringType`	`clusteringType`
`protected SQLExpr`	`comment`
`protected Boolean`	`compress`
`protected boolean`	`dimension`
`protected SQLExpr`	`engine`
`protected boolean`	`external`
`protected boolean`	`ifNotExists`
`protected boolean`	`ignore`
`protected SQLExprTableSource`	`inherits`
`protected SQLExprTableSource`	`like`
`protected SQLExpr`	`location`
`protected Boolean`	`logging`
`protected boolean`	`onCommitDeleteRows`
`protected boolean`	`onCommitPreserveRows`
`protected List<SQLColumnDefinition>`	`partitionColumns`
`protected SQLPartitionBy`	`partitioning`
`protected boolean`	`replace`
`protected SQLExternalRecordFormat`	`rowFormat`
`protected SQLSelect`	`select`
`protected int`	`shards`
`protected List<SQLSelectOrderByItem>`	`sortedBy`
`protected SQLExpr`	`storedAs`
`protected List<SQLTableElement>`	`tableElementList`
`protected List<SQLAssignItem>`	`tableOptions`
`protected SQLExprTableSource`	`tableSource`
`protected SQLName`	`tablespace`
`protected List<SQLAssignItem>`	`tblProperties`
`protected SQLCreateTableStatement.Type`	`type`

从类继承的字段 com.shulie.druid.sql.ast.SQLStatementImpl
afterSemi, dbType, headHints

从类继承的字段 com.shulie.druid.sql.ast.SQLObjectImpl
attributes, hint, parent, sourceColumn, sourceLine

构造器概要

构造器
构造器和说明

SQLCreateTableStatement()

SQLCreateTableStatement(DbType dbType)

构造器
构造器和说明
`SQLCreateTableStatement()`
`SQLCreateTableStatement(DbType dbType)`

方法概要

所有方法静态方法实例方法具体方法
限定符和类型	方法和说明
`protected void`	`accept0(SQLASTVisitor v)`
`protected void`	`acceptChild(SQLASTVisitor v)`
`void`	`addBodyBeforeComment(List<String> comments)`
`void`	`addClusteredByItem(SQLSelectOrderByItem item)`
`void`	`addColumn(SQLColumnDefinition column)`
`void`	`addColumn(String columnName, String dataType)`
`void`	`addOption(String name, SQLExpr value)`
`void`	`addPartitionColumn(SQLColumnDefinition column)`
`void`	`addSortedByItem(SQLSelectOrderByItem item)`
`void`	`addTblProperty(String name, SQLExpr value)`
`protected boolean`	`alterApply(SQLAlterTableItem item)`
`protected boolean`	`apply(SQLAlterTableAddIndex item)`
`boolean`	`apply(SQLAlterTableStatement alter)`
`boolean`	`apply(SQLCommentStatement x)`
`boolean`	`apply(SQLDropIndexStatement x)`
`SQLCreateTableStatement`	`clone()`
`void`	`cloneTo(SQLCreateTableStatement x)`
`protected int`	`columnIndexOf(SQLName column)`
`String`	`computeName()`
`boolean`	`containsDuplicateColumnNames()`
`boolean`	`containsDuplicateColumnNames(boolean throwException)`
`SQLColumnDefinition`	`findColumn(long columName_hash)`
`SQLColumnDefinition`	`findColumn(String columName)`
`List<SQLForeignKeyConstraint>`	`findForeignKey()`
`SQLTableElement`	`findIndex(String columnName)`
`SQLPrimaryKey`	`findPrimaryKey()`
`MySqlUnique`	`findUnique(String columnName)`
`void`	`forEachColumn(Consumer<SQLColumnDefinition> columnConsumer)`
`SQLAlterTableStatement`	`foreignKeyToAlterTable()`
`List<String>`	`getBodyBeforeCommentsDirect()`
`int`	`getBuckets()`
`String`	`getCatalog()`
`List<SQLObject>`	`getChildren()`
`List<SQLSelectOrderByItem>`	`getClusteredBy()`
`ClusteringType`	`getClusteringType()`
`SQLColumnDefinition`	`getColumn(String columnName)`
`List<String>`	`getColumnComments()`
`List<SQLColumnDefinition>`	`getColumnDefinitions()`
`List<String>`	`getColumnNames(boolean normalized)`
`SQLExpr`	`getComment()`
`Boolean`	`getCompress()`
`SQLExpr`	`getEngine()`
`SQLExprTableSource`	`getInherits()`
`SQLExprTableSource`	`getLike()`
`SQLExpr`	`getLocation()`
`Boolean`	`getLogging()`
`SQLName`	`getName()`
`SQLExpr`	`getOption(String name)`
`Object`	`getOptionOrTblPropertyValue(String name)`
`Object`	`getOptionValue(String name)`
`List<SQLColumnDefinition>`	`getPartitionColumns()`
`SQLPartitionBy`	`getPartitioning()`
`List<String>`	`getPrimaryKeyNames()`
`SQLExternalRecordFormat`	`getRowFormat()`
`String`	`getSchema()`
`SQLSelect`	`getSelect()`
`int`	`getShards()`
`List<SQLSelectOrderByItem>`	`getSortedBy()`
`SQLExpr`	`getStoredAs()`
`List<SQLTableElement>`	`getTableElementList()`
`String`	`getTableName()`
`List<SQLAssignItem>`	`getTableOptions()`
`SQLExprTableSource`	`getTableSource()`
`SQLName`	`getTablespace()`
`List<SQLAssignItem>`	`getTblProperties()`
`SQLExpr`	`getTblProperty(String name)`
`Object`	`getTblPropertyValue(String name)`
`SQLCreateTableStatement.Type`	`getType()`
`boolean`	`hasBodyBeforeComment()`
`boolean`	`hashForeignKey()`
`boolean`	`isDimension()`
`boolean`	`isExternal()`
`boolean`	`isIfNotExists()`
`boolean`	`isIgnore()`
`boolean`	`isMUL(String columnName)` only for show columns
`boolean`	`isOnCommitPreserveRows()`
`boolean`	`isOnlyPrimaryKey(long columnNameHash)`
`boolean`	`isPrimaryColumn(long columnNameHash)`
`boolean`	`isPrimaryColumn(String columnName)`
`boolean`	`isReferenced(SQLName tableName)`
`boolean`	`isReferenced(String tableName)`
`boolean`	`isReplace()`
`boolean`	`isUNI(String columnName)` only for show columns
`boolean`	`renameColumn(String colummName, String newColumnName)`
`void`	`setBuckets(int buckets)`
`void`	`setClusteringType(ClusteringType clusteringType)`
`void`	`setComment(SQLExpr comment)`
`void`	`setCompress(Boolean compress)`
`void`	`setDimension(boolean dimension)`
`void`	`setEngine(SQLExpr x)`
`void`	`setExternal(boolean external)`
`void`	`setIfNotExiists(boolean ifNotExists)`
`void`	`setIgnore(boolean ignore)`
`void`	`setInherits(SQLExprTableSource inherits)`
`void`	`setLike(SQLExprTableSource like)`
`void`	`setLike(SQLName like)`
`void`	`setLocation(SQLExpr x)`
`void`	`setLogging(Boolean logging)`
`void`	`setName(SQLName name)`
`void`	`setName(String name)`
`void`	`setOnCommitPreserveRows(boolean onCommitPreserveRows)`
`void`	`setPartitioning(SQLPartitionBy partitioning)`
`void`	`setReplace(boolean replace)`
`void`	`setRowFormat(SQLExternalRecordFormat x)`
`void`	`setSchema(String name)`
`void`	`setSelect(SQLSelect select)`
`void`	`setShards(int shards)`
`void`	`setStoredAs(SQLExpr x)`
`void`	`setTableName(String tableName)`
`void`	`setTableSource(SQLExprTableSource tableSource)`
`void`	`setTablespace(SQLName x)`
`void`	`setType(SQLCreateTableStatement.Type type)`
`void`	`simplify()`
`static void`	`sort(List<SQLStatement> stmtList)`
`String`	`toString()`

从类继承的方法 com.shulie.druid.sql.ast.SQLStatementImpl
getDbType, getHeadHintsDirect, isAfterSemi, setAfterSemi, setDbType, setHeadHints, toLowerCaseString, toParameterizedString, toString, toUnformattedString

从类继承的方法 com.shulie.druid.sql.ast.SQLObjectImpl
accept, acceptChild, acceptChild, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, computeDataType, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getHint, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, output, putAttribute, setHint, setParent, setSourceColumn, setSourceLine

从类继承的方法 java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

从接口继承的方法 com.shulie.druid.sql.ast.SQLStatement
getDbType, getHeadHintsDirect, isAfterSemi, setAfterSemi, setHeadHints, toLowerCaseString, toParameterizedString, toString

从接口继承的方法 com.shulie.druid.sql.ast.SQLObject
accept, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getParent, hasAfterComment, hasBeforeComment, output, output, putAttribute, setParent

字段详细资料

ifNotExists
```
protected boolean ifNotExists
```

type

protected SQLCreateTableStatement.Type type

tableSource

protected SQLExprTableSource tableSource

tableElementList

protected List<SQLTableElement> tableElementList

inherits
```
protected SQLExprTableSource inherits
```

select
```
protected SQLSelect select
```

comment
```
protected SQLExpr comment
```

like
```
protected SQLExprTableSource like
```

compress
```
protected Boolean compress
```

logging
```
protected Boolean logging
```

tablespace
```
protected SQLName tablespace
```

partitioning
```
protected SQLPartitionBy partitioning
```

storedAs
```
protected SQLExpr storedAs
```

location
```
protected SQLExpr location
```

onCommitPreserveRows
```
protected boolean onCommitPreserveRows
```

onCommitDeleteRows
```
protected boolean onCommitDeleteRows
```

external
```
protected boolean external
```

rowFormat

protected SQLExternalRecordFormat rowFormat

partitionColumns

protected final List<SQLColumnDefinition> partitionColumns

clusteringType

protected ClusteringType clusteringType

clusteredBy

protected final List<SQLSelectOrderByItem> clusteredBy

sortedBy

protected final List<SQLSelectOrderByItem> sortedBy

buckets
```
protected int buckets
```

shards
```
protected int shards
```

tableOptions

protected final List<SQLAssignItem> tableOptions

tblProperties

protected final List<SQLAssignItem> tblProperties

replace
```
protected boolean replace
```

ignore
```
protected boolean ignore
```

dimension
```
protected boolean dimension
```

engine
```
protected SQLExpr engine
```

构造器详细资料

SQLCreateTableStatement
```
public SQLCreateTableStatement()
```

SQLCreateTableStatement

public SQLCreateTableStatement(DbType dbType)

方法详细资料

accept0
```
protected void accept0(SQLASTVisitor v)
```
覆盖:

accept0 在类中 SQLStatementImpl

acceptChild

protected void acceptChild(SQLASTVisitor v)

getComment
```
public SQLExpr getComment()
```

setComment

public void setComment(SQLExpr comment)

getName
```
public SQLName getName()
```

getTableName
```
public String getTableName()
```

getSchema
```
public String getSchema()
```

setSchema
```
public void setSchema(String name)
```

setName
```
public void setName(SQLName name)
```

setName
```
public void setName(String name)
```

getTableSource

public SQLExprTableSource getTableSource()

setTableSource

public void setTableSource(SQLExprTableSource tableSource)

setTableName

public void setTableName(String tableName)

getType

public SQLCreateTableStatement.Type getType()

setType

public void setType(SQLCreateTableStatement.Type type)

getTableElementList

public List<SQLTableElement> getTableElementList()

getColumn

public SQLColumnDefinition getColumn(String columnName)

getColumnDefinitions

public List<SQLColumnDefinition> getColumnDefinitions()

getColumnNames

public List<String> getColumnNames(boolean normalized)

getColumnComments

public List<String> getColumnComments()

getPrimaryKeyNames

public List<String> getPrimaryKeyNames()

addColumn

public void addColumn(String columnName,
                      String dataType)

addColumn

public void addColumn(SQLColumnDefinition column)

isIfNotExists
```
public boolean isIfNotExists()
```

setIfNotExiists

public void setIfNotExiists(boolean ifNotExists)

getInherits

public SQLExprTableSource getInherits()

setInherits

public void setInherits(SQLExprTableSource inherits)

getSelect
```
public SQLSelect getSelect()
```

setSelect

public void setSelect(SQLSelect select)

getLike
```
public SQLExprTableSource getLike()
```

setLike
```
public void setLike(SQLName like)
```

setLike

public void setLike(SQLExprTableSource like)

getCompress
```
public Boolean getCompress()
```

setCompress

public void setCompress(Boolean compress)

getLogging
```
public Boolean getLogging()
```

setLogging

public void setLogging(Boolean logging)

getTablespace
```
public SQLName getTablespace()
```

setTablespace
```
public void setTablespace(SQLName x)
```

getPartitioning

public SQLPartitionBy getPartitioning()

setPartitioning

public void setPartitioning(SQLPartitionBy partitioning)

getChildren
```
public List<SQLObject> getChildren()
```
指定者:

getChildren 在接口中 SQLStatement

覆盖:

getChildren 在类中 SQLStatementImpl

addBodyBeforeComment

public void addBodyBeforeComment(List<String> comments)

getBodyBeforeCommentsDirect

public List<String> getBodyBeforeCommentsDirect()

hasBodyBeforeComment
```
public boolean hasBodyBeforeComment()
```

computeName
```
public String computeName()
```

findColumn

public SQLColumnDefinition findColumn(String columName)

findColumn

public SQLColumnDefinition findColumn(long columName_hash)

isPrimaryColumn

public boolean isPrimaryColumn(String columnName)

isPrimaryColumn

public boolean isPrimaryColumn(long columnNameHash)

isOnlyPrimaryKey

public boolean isOnlyPrimaryKey(long columnNameHash)

isMUL

public boolean isMUL(String columnName)

only for show columns

isUNI

public boolean isUNI(String columnName)

only for show columns

findUnique

public MySqlUnique findUnique(String columnName)

findIndex

public SQLTableElement findIndex(String columnName)

forEachColumn

public void forEachColumn(Consumer<SQLColumnDefinition> columnConsumer)

findPrimaryKey
```
public SQLPrimaryKey findPrimaryKey()
```

findForeignKey

public List<SQLForeignKeyConstraint> findForeignKey()

hashForeignKey
```
public boolean hashForeignKey()
```

isReferenced

public boolean isReferenced(SQLName tableName)

isReferenced

public boolean isReferenced(String tableName)

foreignKeyToAlterTable

public SQLAlterTableStatement foreignKeyToAlterTable()

sort

public static void sort(List<SQLStatement> stmtList)

simplify
```
public void simplify()
```

apply

public boolean apply(SQLDropIndexStatement x)

apply

public boolean apply(SQLCommentStatement x)

apply

public boolean apply(SQLAlterTableStatement alter)

alterApply

protected boolean alterApply(SQLAlterTableItem item)

renameColumn

public boolean renameColumn(String colummName,
                            String newColumnName)

apply

protected boolean apply(SQLAlterTableAddIndex item)

columnIndexOf

protected int columnIndexOf(SQLName column)

cloneTo

public void cloneTo(SQLCreateTableStatement x)

isReplace
```
public boolean isReplace()
```

setReplace

public void setReplace(boolean replace)

isIgnore
```
public boolean isIgnore()
```

setIgnore

public void setIgnore(boolean ignore)

getStoredAs
```
public SQLExpr getStoredAs()
```

setStoredAs
```
public void setStoredAs(SQLExpr x)
```

clone
```
public SQLCreateTableStatement clone()
```
指定者:

clone 在接口中 SQLObject

指定者:

clone 在接口中 SQLStatement

覆盖:

clone 在类中 SQLStatementImpl

toString
```
public String toString()
```
指定者:

toString 在接口中 SQLStatement

覆盖:

toString 在类中 SQLStatementImpl

isOnCommitPreserveRows

public boolean isOnCommitPreserveRows()

setOnCommitPreserveRows

public void setOnCommitPreserveRows(boolean onCommitPreserveRows)

isExternal
```
public boolean isExternal()
```

setExternal

public void setExternal(boolean external)

getClusteringType

public ClusteringType getClusteringType()

setClusteringType

public void setClusteringType(ClusteringType clusteringType)

getClusteredBy

public List<SQLSelectOrderByItem> getClusteredBy()

addClusteredByItem

public void addClusteredByItem(SQLSelectOrderByItem item)

getSortedBy

public List<SQLSelectOrderByItem> getSortedBy()

addSortedByItem

public void addSortedByItem(SQLSelectOrderByItem item)

getBuckets
```
public int getBuckets()
```

setBuckets
```
public void setBuckets(int buckets)
```

getShards
```
public int getShards()
```

setShards
```
public void setShards(int shards)
```

getPartitionColumns

public List<SQLColumnDefinition> getPartitionColumns()

addPartitionColumn

public void addPartitionColumn(SQLColumnDefinition column)

getTableOptions

public List<SQLAssignItem> getTableOptions()

getTblProperties

public List<SQLAssignItem> getTblProperties()

addTblProperty

public void addTblProperty(String name,
                           SQLExpr value)

getRowFormat

public SQLExternalRecordFormat getRowFormat()

setRowFormat

public void setRowFormat(SQLExternalRecordFormat x)

isDimension
```
public boolean isDimension()
```

setDimension

public void setDimension(boolean dimension)

getLocation
```
public SQLExpr getLocation()
```

setLocation
```
public void setLocation(SQLExpr x)
```

addOption

public void addOption(String name,
                      SQLExpr value)

getOption

public SQLExpr getOption(String name)

getTblProperty

public SQLExpr getTblProperty(String name)

getOptionValue

public Object getOptionValue(String name)

getTblPropertyValue

public Object getTblPropertyValue(String name)

getOptionOrTblPropertyValue

public Object getOptionOrTblPropertyValue(String name)

getCatalog
```
public String getCatalog()
```

containsDuplicateColumnNames

public boolean containsDuplicateColumnNames()

containsDuplicateColumnNames

public boolean containsDuplicateColumnNames(boolean throwException)

getEngine
```
public SQLExpr getEngine()
```

setEngine
```
public void setEngine(SQLExpr x)
```

类 SQLCreateTableStatement

嵌套类概要

字段概要

从类继承的字段 com.shulie.druid.sql.ast.SQLStatementImpl

从类继承的字段 com.shulie.druid.sql.ast.SQLObjectImpl

构造器概要

方法概要

从类继承的方法 com.shulie.druid.sql.ast.SQLStatementImpl

从类继承的方法 com.shulie.druid.sql.ast.SQLObjectImpl

从类继承的方法 java.lang.Object

从接口继承的方法 com.shulie.druid.sql.ast.SQLStatement

从接口继承的方法 com.shulie.druid.sql.ast.SQLObject

字段详细资料

ifNotExists

type

tableSource

tableElementList

inherits

select

comment

like

compress

logging

tablespace

partitioning

storedAs

location

onCommitPreserveRows

onCommitDeleteRows

external

rowFormat

partitionColumns

clusteringType

clusteredBy

sortedBy

buckets

shards

tableOptions

tblProperties

replace

ignore

dimension

engine

构造器详细资料

SQLCreateTableStatement

SQLCreateTableStatement

方法详细资料

accept0

acceptChild

getComment

setComment

getName

getTableName

getSchema

setSchema

setName

setName

getTableSource

setTableSource

setTableName

getType

setType

getTableElementList

getColumn

getColumnDefinitions

getColumnNames

getColumnComments

getPrimaryKeyNames

addColumn

addColumn

isIfNotExists

setIfNotExiists

getInherits

setInherits

getSelect

setSelect

getLike

setLike

setLike

getCompress