TCreateTableSqlStatement (gudusoft.gsqlparser 2.0.1.0 API)

java.lang.Object
- gudusoft.gsqlparser.nodes.TParseTreeNode
- - gudusoft.gsqlparser.TCustomSqlStatement
  - - gudusoft.gsqlparser.stmt.TCreateTableSqlStatement

All Implemented Interfaces:

Visitable
```
public class TCreateTableSqlStatement
extends TCustomSqlStatement
```
SQL create table statement.
TCustomSqlStatement.getTargetTable() returns the created table. getColumnList() returns columns created in the table.
getTableConstraints() returns table level constraints if any.
getSubQuery() returns select statement that generate data for this table.

Example:
```
     CREATE TABLE dbo.Employee (EmployeeID int PRIMARY KEY CLUSTERED);
 
```
Table:dbo.Employee can be fetched from TCustomSqlStatement.getTargetTable() or the first element of TCustomSqlStatement.tables
column definitions: can be fetched from getColumnList()
table constraints: getTableConstraints()
See Also:

TCustomSqlStatement#targetTable}, {@link TColumnDefinition}

Field Summary
- Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement
  dbvendor, dummytag, isparsed, joins, parser, plsqlparser, rootNode, sourcetokenlist, sqlstatementtype, tables

Constructor Summary

Constructors
Constructor and Description

TCreateTableSqlStatement(EDbVendor dbvendor)

Constructors
Constructor and Description
`TCreateTableSqlStatement(EDbVendor dbvendor)`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`accept(TParseTreeVisitor v)` Accept a visitor
`void`	`acceptChildren(TParseTreeVisitor v)` Accept a visitor to iterate this class and sub-nodes of this class
`int`	`doParseStatement(TCustomSqlStatement psql)`
`TTable`	`getAsTable()` Netezza, Teradata, as table name.
`TColumnDefinitionList`	`getColumnList()` columns created in create table statement.
`TExecutePreparedStatement`	`getExecutePreparedStatement()`
`THiveRowFormat`	`getHiveRowFormat()` Hive, impala table row format
`THiveTableBuckets`	`getHiveTableBuckets()` Hive, Impala table buckets
`THiveTableFileFormat`	`getHiveTableFileFormat()` Hive, Impala table file format
`THiveTablePartition`	`getHiveTablePartition()` Hive, Impala table partition
`THiveTableProperties`	`getHiveTableProperties()` Hive, Impala table properties
`THiveTableSkewed`	`getHiveTableSkewed()` Hive, Impala skewed by clause.
`TPTNodeList<TIndexDefinition>`	`getIndexDefinitions()` Teradata index definition
`TObjectName`	`getLikeTableName()` Greenplum, table used in like clause.
`TPTNodeList<TMySQLCreateTableOption>`	`getMySQLTableOptionList()` MySQL, option used in create table such as engine, auto_increment and etc.
`TPhysicalProperties`	`getPhysicalProperties()` Oracle physical properties
`TObjectName`	`getRowTypeName()` Informix, typename used in of type clause.
`TSelectSqlStatement`	`getSubQuery()` Data of the created table is derived from this select statement.
`TObjectName`	`getSuperTableName()` Informix, table name used in the under clause.
`TObjectName`	`getTableComment()` Hive, Impala, comment of the table.
`TConstraintList`	`getTableConstraints()` table level constraints.
`EnumSet<ETableKind>`	`getTableKinds()` Type of this table
`TObjectName`	`getTableLocation()` Hive, Impala, location of the table.
`TObjectName`	`getTableName()` The first table in `TCustomSqlStatement.tables`, this is the same table as `TCustomSqlStatement.getTargetTable()`
`boolean`	`isExternal()` Hive, Impala,Netezza, whether it is a external table
`boolean`	`isExternalTable()` Deprecated. As of v1.9.7.2 , replace by `isExternal()` Netezza, whether it is a external table
`boolean`	`isIfNotExists()` Hive, Impala, if not exists clause
`void`	`setAsTable(TTable asTable)`
`void`	`setColumnList(TColumnDefinitionList columnList)`
`void`	`setExecutePreparedStatement(TExecutePreparedStatement executePreparedStatement)`
`void`	`setExternal(boolean external)`
`void`	`setExternalTable(boolean externalTable)`
`void`	`setHiveRowFormat(THiveRowFormat hiveRowFormat)`
`void`	`setHiveTableBuckets(THiveTableBuckets hiveTableBuckets)`
`void`	`setHiveTableFileFormat(THiveTableFileFormat hiveTableFileFormat)`
`void`	`setHiveTablePartition(THiveTablePartition hiveTablePartition)`
`void`	`setHiveTableProperties(THiveTableProperties hiveTableProperties)`
`void`	`setHiveTableSkewed(THiveTableSkewed hiveTableSkewed)`
`void`	`setIfNotExists(boolean ifNotExists)`
`void`	`setIndexDefinitions(TPTNodeList<TIndexDefinition> indexDefinitions)`
`void`	`setLikeTableName(TObjectName likeTableName)`
`void`	`setMySQLTableOptionList(TPTNodeList<TMySQLCreateTableOption> mySQLTableOptionList)`
`void`	`setRowTypeName(TObjectName rowTypeName)`
`void`	`setSubQuery(TSelectSqlStatement subQuery)`
`void`	`setSuperTableName(TObjectName superTableName)`
`void`	`setTableComment(TObjectName tableComment)`
`void`	`setTableConstraints(TConstraintList tableConstraints)`
`void`	`setTableKinds(EnumSet<ETableKind> tableKinds)`
`void`	`setTableLocation(TObjectName tableLocation)`
`void`	`setTableName(TObjectName tableName)`

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement
addToTables, addWhereClause, analyzeFromTable, analyzeJoin, analyzeTablename, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getFirstPhysicalTable, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentStmt, getResultColumnList, getReturningClause, getStatements, getSymbolTable, getTables, getTargetTable, getTopClause, getTopStatement, getVariableStack, getWhereClause, isnzplsql, isoracleplsql, ispgplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, searchCTEList, searchDaxVariableInStack, setCteList, setEndlabelName, setLabelName, setOutputClause, setParentStmt, setResultColumnList, setReturningClause, setTargetTable, setTopClause, setVariableStack, setWhereClause, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
addAllMyTokensToTokenList, appendString, doParse, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - TCreateTableSqlStatement
```
public TCreateTableSqlStatement(EDbVendor dbvendor)
```
- Method Detail
  - getPhysicalProperties
```
public TPhysicalProperties getPhysicalProperties()
```
    Oracle physical properties
    
    Returns:
    
    Oracle physical properties
  - setTableKinds
```
public void setTableKinds(EnumSet<ETableKind> tableKinds)
```
  - getTableKinds
```
public EnumSet<ETableKind> getTableKinds()
```
    Type of this table
    
    Returns:
    
    Type of this table
  - getAsTable
```
public TTable getAsTable()
```
    Netezza, Teradata, as table name.
    
    Returns:
    
    as table name
  - isExternalTable
```
public boolean isExternalTable()
```
    Deprecated. As of v1.9.7.2 , replace by isExternal()
    Netezza, whether it is a external table
    
    Returns:
    
    true if it's netezza create external table
  - getIndexDefinitions
```
public TPTNodeList<TIndexDefinition> getIndexDefinitions()
```
    Teradata index definition
```
UNIQUE PRIMARY INDEX (storeid, productid, salesdate)
```
    Returns:
    
    list of index definition
  - isExternal
```
public boolean isExternal()
```
    Hive, Impala,Netezza, whether it is a external table
    
    Returns:
    
    whether it is a external table
  - getHiveRowFormat
```
public THiveRowFormat getHiveRowFormat()
```
    Hive, impala table row format
    
    Returns:
    
    table row format
  - getHiveTableBuckets
```
public THiveTableBuckets getHiveTableBuckets()
```
    Hive, Impala table buckets
    
    Returns:
    
    table buckets
  - getHiveTableFileFormat
```
public THiveTableFileFormat getHiveTableFileFormat()
```
    Hive, Impala table file format
    
    Returns:
    
    table file format
  - getHiveTablePartition
```
public THiveTablePartition getHiveTablePartition()
```
    Hive, Impala table partition
    
    Returns:
    
    table partition
  - getHiveTableProperties
```
public THiveTableProperties getHiveTableProperties()
```
    Hive, Impala table properties
    
    Returns:
    
    table properties
  - getHiveTableSkewed
```
public THiveTableSkewed getHiveTableSkewed()
```
    Hive, Impala skewed by clause.
    
    Returns:
    
    skewed by clause.
  - isIfNotExists
```
public boolean isIfNotExists()
```
    Hive, Impala, if not exists clause
    
    Returns:
    
    true if not exists clause is used in create table statement
  - getLikeTableName
```
public TObjectName getLikeTableName()
```
    Greenplum, table used in like clause.
    Hive, Impala, table used in like clause.
    
    Returns:
    
    table used in like clause.
  - getTableComment
```
public TObjectName getTableComment()
```
    Hive, Impala, comment of the table.
    
    Returns:
    
    comment of the table.
  - getTableLocation
```
public TObjectName getTableLocation()
```
    Hive, Impala, location of the table.
    
    Returns:
    
    location of the table.
  - getRowTypeName
```
public TObjectName getRowTypeName()
```
    Informix, typename used in of type clause.
    
    Returns:
    
    row type name
  - getSuperTableName
```
public TObjectName getSuperTableName()
```
    Informix, table name used in the under clause.
    
    Returns:
    
    table name used in the under clause.
  - getSubQuery
```
public TSelectSqlStatement getSubQuery()
```
    Data of the created table is derived from this select statement.
    
    Returns:
    
    TSelectSqlStatement used in create table.
  - getExecutePreparedStatement
```
public TExecutePreparedStatement getExecutePreparedStatement()
```
  - getMySQLTableOptionList
```
public TPTNodeList<TMySQLCreateTableOption> getMySQLTableOptionList()
```
    MySQL, option used in create table such as engine, auto_increment and etc.
    
    Returns:
    
    option used in create table such as engine, auto_increment and etc.
  - getTableName
```
public TObjectName getTableName()
```
    The first table in TCustomSqlStatement.tables, this is the same table as TCustomSqlStatement.getTargetTable()
    
    Returns:
    
    The first table in TCustomSqlStatement.tables
  - doParseStatement
```
public int doParseStatement(TCustomSqlStatement psql)
```
    Overrides:
    
    doParseStatement in class TCustomSqlStatement
  - getTableConstraints
```
public TConstraintList getTableConstraints()
```
    table level constraints.
    
    Returns:
    
    List of table constraints of this table.
  - getColumnList
```
public TColumnDefinitionList getColumnList()
```
    columns created in create table statement.
    
    Returns:
    
    List of column definitions of this table.
  - accept
```
public void accept(TParseTreeVisitor v)
```
    Description copied from class: TParseTreeNode
    
    Accept a visitor
    
    Specified by:
    
    accept in interface Visitable
    
    Overrides:
    
    accept in class TParseTreeNode
    
    Parameters:
    
    v - visitor is a descendant class of TParseTreeVisitor
  - acceptChildren
```
public void acceptChildren(TParseTreeVisitor v)
```
    Description copied from class: TParseTreeNode
    
    Accept a visitor to iterate this class and sub-nodes of this class
    
    Specified by:
    
    acceptChildren in interface Visitable
    
    Overrides:
    
    acceptChildren in class TParseTreeNode
    
    Parameters:
    
    v - visitor is a descendant class of TParseTreeVisitor
  - setColumnList
```
public void setColumnList(TColumnDefinitionList columnList)
```
  - setAsTable
```
public void setAsTable(TTable asTable)
```
  - setExternalTable
```
public void setExternalTable(boolean externalTable)
```
  - setIndexDefinitions
```
public void setIndexDefinitions(TPTNodeList<TIndexDefinition> indexDefinitions)
```
  - setExternal
```
public void setExternal(boolean external)
```
  - setIfNotExists
```
public void setIfNotExists(boolean ifNotExists)
```
  - setTableLocation
```
public void setTableLocation(TObjectName tableLocation)
```
  - setTableComment
```
public void setTableComment(TObjectName tableComment)
```
  - setHiveTableProperties
```
public void setHiveTableProperties(THiveTableProperties hiveTableProperties)
```
  - setHiveTablePartition
```
public void setHiveTablePartition(THiveTablePartition hiveTablePartition)
```
  - setHiveTableBuckets
```
public void setHiveTableBuckets(THiveTableBuckets hiveTableBuckets)
```
  - setHiveTableSkewed
```
public void setHiveTableSkewed(THiveTableSkewed hiveTableSkewed)
```
  - setHiveRowFormat
```
public void setHiveRowFormat(THiveRowFormat hiveRowFormat)
```
  - setHiveTableFileFormat
```
public void setHiveTableFileFormat(THiveTableFileFormat hiveTableFileFormat)
```
  - setLikeTableName
```
public void setLikeTableName(TObjectName likeTableName)
```
  - setRowTypeName
```
public void setRowTypeName(TObjectName rowTypeName)
```
  - setSuperTableName
```
public void setSuperTableName(TObjectName superTableName)
```
  - setSubQuery
```
public void setSubQuery(TSelectSqlStatement subQuery)
```
  - setExecutePreparedStatement
```
public void setExecutePreparedStatement(TExecutePreparedStatement executePreparedStatement)
```
  - setMySQLTableOptionList
```
public void setMySQLTableOptionList(TPTNodeList<TMySQLCreateTableOption> mySQLTableOptionList)
```
  - setTableName
```
public void setTableName(TObjectName tableName)
```
  - setTableConstraints
```
public void setTableConstraints(TConstraintList tableConstraints)
```

Class TCreateTableSqlStatement

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

Constructor Summary

Method Summary

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

Methods inherited from class java.lang.Object

Constructor Detail

TCreateTableSqlStatement

Method Detail

getPhysicalProperties

setTableKinds

getTableKinds

getAsTable

isExternalTable

getIndexDefinitions

isExternal

getHiveRowFormat

getHiveTableBuckets

getHiveTableFileFormat

getHiveTablePartition

getHiveTableProperties

getHiveTableSkewed

isIfNotExists

getLikeTableName

getTableComment

getTableLocation

getRowTypeName

getSuperTableName

getSubQuery

getExecutePreparedStatement

getMySQLTableOptionList

getTableName

doParseStatement

getTableConstraints

getColumnList

accept

acceptChildren

setColumnList

setAsTable

setExternalTable

setIndexDefinitions

setExternal

setIfNotExists

setTableLocation

setTableComment

setHiveTableProperties

setHiveTablePartition

setHiveTableBuckets

setHiveTableSkewed

setHiveRowFormat

setHiveTableFileFormat

setLikeTableName

setRowTypeName

setSuperTableName

setSubQuery

setExecutePreparedStatement

setMySQLTableOptionList

setTableName

setTableConstraints