Table of Contents

Class TCreateTableSqlStatement

Namespace
gudusoft.gsqlparser.stmt
Assembly
gudusoft.gsqlparser.dll

This class represents create table statement.

    CREATE TABLE dbo.Employee (EmployeeID int PRIMARY KEY CLUSTERED);

Table:dbo.Employee can be fetched from TargetTable or tables column definitions: can be fetched from ColumnList

Dependency check, in order to create this table, following objects must be created already if necessary:

  • table/view in column reference constraint
  • function/procedure used in default check constraint
  • table/view in sub-query if this table created from a select statement.
table constraints: TableConstraints 
public class TCreateTableSqlStatement : TCustomSqlStatement, Visitable
Inheritance
TCreateTableSqlStatement
Implements
Inherited Members

Constructors

TCreateTableSqlStatement(EDbVendor) 

public TCreateTableSqlStatement(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

AsTable 

public virtual TTable AsTable { get; set; }

Property Value

TTable

ColumnList 

public virtual TColumnDefinitionList ColumnList { get; set; }

Property Value

TColumnDefinitionList

List of column definitions of this table.

ExecutePreparedStatement 

public virtual TExecutePreparedStatement ExecutePreparedStatement { get; set; }

Property Value

TExecutePreparedStatement

External 

public virtual bool External { get; set; }

Property Value

bool

ExternalTable 

public virtual bool ExternalTable { get; set; }

Property Value

bool

true if it's netezza create external table

HiveRowFormat 

public virtual THiveRowFormat HiveRowFormat { get; set; }

Property Value

THiveRowFormat

HiveTableBuckets 

public virtual THiveTableBuckets HiveTableBuckets { get; set; }

Property Value

THiveTableBuckets

HiveTableFileFormat 

public virtual THiveTableFileFormat HiveTableFileFormat { get; set; }

Property Value

THiveTableFileFormat

HiveTablePartition 

public virtual THiveTablePartition HiveTablePartition { get; set; }

Property Value

THiveTablePartition

HiveTableProperties 

public virtual THiveTableProperties HiveTableProperties { get; set; }

Property Value

THiveTableProperties

HiveTableSkewed 

public virtual THiveTableSkewed HiveTableSkewed { get; set; }

Property Value

THiveTableSkewed

IfNotExists 

public virtual bool IfNotExists { get; set; }

Property Value

bool

IndexDefinitions

Teradata index definition

UNIQUE PRIMARY INDEX (storeid, productid, salesdate)
public virtual List<TIndexDefinition> IndexDefinitions { get; set; }

Property Value

List<TIndexDefinition>

list of index definition

LikeTableName 

public virtual TObjectName LikeTableName { get; set; }

Property Value

TObjectName

MySQLTableOptionList 

public virtual List<TMySQLCreateTableOption> MySQLTableOptionList { get; set; }

Property Value

List<TMySQLCreateTableOption>

RowTypeName 

public virtual TObjectName RowTypeName { get; set; }

Property Value

TObjectName

row type name of informix create table of row type

SubQuery 

public virtual TSelectSqlStatement SubQuery { get; set; }

Property Value

TSelectSqlStatement

TSelectSqlStatement used in create table.

SuperTableName 

public virtual TObjectName SuperTableName { get; set; }

Property Value

TObjectName

super table name of informix create table of row type under super table

TableComment 

public virtual TObjectName TableComment { get; set; }

Property Value

TObjectName

TableConstraints 

public virtual TConstraintList TableConstraints { get; set; }

Property Value

TConstraintList

List of table constraints of this table.

TableLocation 

public virtual TObjectName TableLocation { get; set; }

Property Value

TObjectName

TableName 

public virtual TObjectName TableName { get; set; }

Property Value

TObjectName

TableOptions 

public List<TCreateTableOption> TableOptions { get; set; }

Property Value

List<TCreateTableOption>

stGlobal 

public TSourceToken stGlobal { get; set; }

Property Value

TSourceToken

stLocal 

public TSourceToken stLocal { get; set; }

Property Value

TSourceToken

stTemp 

public TSourceToken stTemp { get; set; }

Property Value

TSourceToken

stTemporary 

public TSourceToken stTemporary { get; set; }

Property Value

TSourceToken

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int
Edit this page