Table of Contents

Class TAlterTableOption

Namespace
gudusoft.gsqlparser.nodes
Assembly
gudusoft.gsqlparser.dll

Type of alter table options, check return value of OptionType:

Column

  • AddColumn, check ColumnDefinitionList for newly added columns
  • AlterColumn, ColumnName, DB2/SQL Server/MySQL/Sybase alter column
  • ChangeColumn, ColumnName,NewColumnDef MySQL change column
    •  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropColumn" data-throw-if-not-resolved="false"></xref>, check <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnNameList" data-throw-if-not-resolved="false"></xref> for dropped columns. <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._dropRestrictType" data-throw-if-not-resolved="false"></xref></li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.ModifyColumn" data-throw-if-not-resolved="false"></xref>, check <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnDefinitionList" data-throw-if-not-resolved="false"></xref> for modified columns</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.RenameColumn" data-throw-if-not-resolved="false"></xref>, rename <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref> to <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.NewColumnName" data-throw-if-not-resolved="false"></xref></li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.SetUnUsedColumn" data-throw-if-not-resolved="false"></xref>, check <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnNameList" data-throw-if-not-resolved="false"></xref> for unused column. Oracle set unused column.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropUnUsedColumn" data-throw-if-not-resolved="false"></xref>, Oracle drop unused columns</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropColumnsContinue" data-throw-if-not-resolved="false"></xref>, Oracle drop columns continue</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnSetDefault" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.DefaultExpr" data-throw-if-not-resolved="false"></xref>. greenplum/netezza/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnDropDefault" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, greenplum/netezza/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnDropNotNull" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnSetNotNull" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnSetStatistics" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.StatisticsValue" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnSetOptions" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnResetOptions" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnSetStorage" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.StorageName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql.</li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterColumnSetDataType" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnName" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.NewDataType" data-throw-if-not-resolved="false"></xref>,  <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.NewCollation" data-throw-if-not-resolved="false"></xref>,<xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.UsingExpr" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql.</li>

Constraint

  • AddConstraint, check ConstraintList for newly added table level constraints
  • AddConstraintPK, ColumnNameList,gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName, MySQL
  • AddConstraintUnique, ColumnNameList, gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName,MySQL
  • AddConstraintFK, ColumnNameList, gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName, ReferencedObjectName, ReferencedColumnList,MySQL
    •  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AddConstraintIndex" data-throw-if-not-resolved="false"></xref>, check <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ColumnNameList" data-throw-if-not-resolved="false"></xref>,
     <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>,<xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.MySQLIndexStorageType" data-throw-if-not-resolved="false"></xref> MySQL add index constraint</li>

 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropConstraint" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.ConstraintNameList" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._dropRestrictType" data-throw-if-not-resolved="false"></xref>, Oracle/DB2/Greenplum drop constraint. </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterConstraintFK" data-throw-if-not-resolved="false"></xref>, DB2 alter foreign key. </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.AlterConstraintCheck" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>, DB2 alter check constraint. </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropConstraintIndex" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>, MySQL drop index </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropConstraintKey" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>, MySQL drop index </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropConstraintPK" data-throw-if-not-resolved="false"></xref>, Oracle/DB2/MySQL drop primary key. </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropConstraintFK" data-throw-if-not-resolved="false"></xref>,<xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>, DB2/MySQL drop foreign key. </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropConstraintUnique" data-throw-if-not-resolved="false"></xref>, In Oracle, get <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._columnNameList" data-throw-if-not-resolved="false"></xref>, In DB2, get <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>. </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.DropConstraintCheck" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>, DB2 drop check constraint. </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.ModifyConstraint" data-throw-if-not-resolved="false"></xref>, check <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref> </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.RenameConstraint" data-throw-if-not-resolved="false"></xref>, rename <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref> to <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref> </li>
 <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.ValidateConstraint" data-throw-if-not-resolved="false"></xref>,  <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption._constraintName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql</li>

Enable/disable

      <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.enableTrigger" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.TriggerName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.enableAlwaysTrigger" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.TriggerName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.enableReplicaTrigger" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.TriggerName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.disableTrigger" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.TriggerName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.enableRule" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.RuleName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.enableAlwaysRule" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.RuleName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.enableReplicaRule" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.RuleName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.disableRule" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.RuleName" data-throw-if-not-resolved="false"></xref>, greenplum. </li>

Others

  • RenameTable, NewTableName
  • inherit, ParentTable, greenplum/postgresql.
  • noInherit, ParentTable, greenplum/postgresql. 
    •   <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.ofAnyType" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.AnyTypeName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>

  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.ownerTo" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.NewOwnerName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>
  <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.setTablespace" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.NewTablespaceName" data-throw-if-not-resolved="false"></xref>, greenplum/postgresql. </li>

   <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.setSchema" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.SchemaName" data-throw-if-not-resolved="false"></xref>, greenplum. </li>
   <li><xref href="gudusoft.gsqlparser.EAlterTableOptionType.clusterOn" data-throw-if-not-resolved="false"></xref>, <xref href="gudusoft.gsqlparser.nodes.TAlterTableOption.IndexName" data-throw-if-not-resolved="false"></xref>, postgresql. </li>

public class TAlterTableOption : TParseTreeNode, Visitable
Inheritance
TAlterTableOption
Implements
Inherited Members

Properties

AnyTypeName 

public virtual TObjectName AnyTypeName { get; set; }

Property Value

TObjectName

AttributeOptions 

public virtual List<TAttributeOption> AttributeOptions { get; set; }

Property Value

List<TAttributeOption>

ColumnDefinitionList

List of TColumnDefinitionList, valid when OptionType is:

AddColumn

ModifyColumn 

public virtual TColumnDefinitionList ColumnDefinitionList { get; set; }

Property Value

TColumnDefinitionList

column definition list

ColumnName 

public virtual TObjectName ColumnName { get; set; }

Property Value

TObjectName

ColumnNameList

List of TObjectNameList, valid when OptionType is:

SetUnUsedColumn

DropColumn

AddConstraintIndex, columns of an index

AddConstraintPK, columns of primary key

AddConstraintUnique, columns of unique key

AddConstraintFK, columns of foreign key

DropConstraintUnique, available in Oracle 

public virtual TObjectNameList ColumnNameList { get; set; }

Property Value

TObjectNameList

column name list

ConstraintList

List of TConstraint, valid when OptionType is:

AddConstraint 

public virtual TConstraintList ConstraintList { get; set; }

Property Value

TConstraintList

constraint list

ConstraintName 

public TObjectName ConstraintName { get; set; }

Property Value

TObjectName

ConstraintNameList

DropConstraint 

public virtual TObjectNameList ConstraintNameList { get; set; }

Property Value

TObjectNameList

constraint name list

DefaultExpr 

public virtual TExpression DefaultExpr { get; set; }

Property Value

TExpression

DropRestrictType 

public EKeyReferenceType DropRestrictType { get; }

Property Value

EKeyReferenceType

ExchangePartitionSpec

exchange partition Spec with table tablename valid when OptionType is:

exchangePartition 

public virtual TPartitionExtensionClause ExchangePartitionSpec { get; set; }

Property Value

TPartitionExtensionClause

exchanged partition spec

FileFormat

valid when OptionType is:

setFileFormat 

public virtual THiveTableFileFormat FileFormat { get; set; }

Property Value

THiveTableFileFormat

hive file format

IndexCols 

public virtual List<TIndexColName> IndexCols { get; set; }

Property Value

List<TIndexColName>

IndexName 

public virtual TObjectName IndexName { get; set; }

Property Value

TObjectName

IndexOptionList 

public virtual List<TMySQLIndexOption> IndexOptionList { get; set; }

Property Value

List<TMySQLIndexOption>

MySQLIndexStorageType 

public virtual TMySQLIndexStorageType MySQLIndexStorageType { get; set; }

Property Value

TMySQLIndexStorageType

MySQLIndexTypeToken 

public virtual TSourceToken MySQLIndexTypeToken { get; set; }

Property Value

TSourceToken

NewCollation 

public virtual TObjectName NewCollation { get; set; }

Property Value

TObjectName

NewColumnDef 

public virtual TColumnDefinition NewColumnDef { get; set; }

Property Value

TColumnDefinition

NewColumnName

valid when OptionType is:

RenameColumn 

public virtual TObjectName NewColumnName { get; set; }

Property Value

TObjectName

new column name

NewConstraintName

valid when OptionType is:

RenameConstraint 

public virtual TObjectName NewConstraintName { get; set; }

Property Value

TObjectName

new constraint name

NewDataType 

public virtual TTypeName NewDataType { get; set; }

Property Value

TTypeName

NewOwnerName 

public virtual TObjectName NewOwnerName { get; set; }

Property Value

TObjectName

NewPartitionSpec

rename to new partition Spec, valid when OptionType is:

renamePartition 

public virtual TPartitionExtensionClause NewPartitionSpec { get; set; }

Property Value

TPartitionExtensionClause

partition spec

NewTableName

table name in alter table tablename rename to newtablename

public virtual TObjectName NewTableName { get; set; }

Property Value

TObjectName

NewTablespaceName 

public virtual TObjectName NewTablespaceName { get; set; }

Property Value

TObjectName

NumberOfBuckets

into number buckets valid when OptionType is:

tableBuckets 

public virtual TConstant NumberOfBuckets { get; set; }

Property Value

TConstant

number of buckets

OptionType 

public virtual EAlterTableOptionType OptionType { get; set; }

Property Value

EAlterTableOptionType

ParentTable 

public virtual TObjectName ParentTable { get; set; }

Property Value

TObjectName

PartitionColumnDef

partition column ( columnDef ) valid when OptionType is:

clusteredSorted 

public virtual TColumnDefinition PartitionColumnDef { get; set; }

Property Value

TColumnDefinition

column definition

PartitionExpression1 

public virtual TExpression PartitionExpression1 { get; set; }

Property Value

TExpression

PartitionExpression2 

public virtual TExpression PartitionExpression2 { get; set; }

Property Value

TExpression

PartitionSpecList

valid when OptionType is:

dropPartitionSpecList

addPartitionSpecList

touch

archive

unArchive 

public virtual List<TPartitionExtensionClause> PartitionSpecList { get; set; }

Property Value

List<TPartitionExtensionClause>

list of TPartitionExtensionClause

ReferencedColumnList 

public virtual TObjectNameList ReferencedColumnList { get; set; }

Property Value

TObjectNameList

ReferencedObjectName 

public virtual TObjectName ReferencedObjectName { get; set; }

Property Value

TObjectName

RuleName 

public virtual TObjectName RuleName { get; set; }

Property Value

TObjectName

SchemaName

setSchema

public virtual TObjectName SchemaName { get; set; }

Property Value

TObjectName

greenplum set schema name

SerdeName

valid when OptionType is:

serde 

public virtual TObjectName SerdeName { get; set; }

Property Value

TObjectName

serde name

SkewedLocations

set skewed location skewedLocations valid when OptionType is:

skewedLocation 

public virtual TExpressionList SkewedLocations { get; set; }

Property Value

TExpressionList

skewed locations

StatisticsValue 

public virtual TConstant StatisticsValue { get; set; }

Property Value

TConstant

StorageName 

public virtual TObjectName StorageName { get; set; }

Property Value

TObjectName

TableBuckets

clustered by ... [sorted by ...] into number buckets valid when OptionType is:

clusteredSorted 

public virtual THiveTableBuckets TableBuckets { get; set; }

Property Value

THiveTableBuckets

table buckets

TableConstraint 

public virtual TConstraint TableConstraint { get; set; }

Property Value

TConstraint

TableLocation

valid when OptionType is:

setLocation 

public virtual TObjectName TableLocation { get; set; }

Property Value

TObjectName

hive file location

TableProperties

valid when OptionType is:

setTableProperties

unsetTableProperties 

public virtual List<THiveKeyValueProperty> TableProperties { get; set; }

Property Value

List<THiveKeyValueProperty>

list of THiveKeyValueProperty

TableSkewed

tableSkewed valid when OptionType is:

tableSkewed 

public virtual THiveTableSkewed TableSkewed { get; set; }

Property Value

THiveTableSkewed

tableSkewed

TriggerName 

public virtual TObjectName TriggerName { get; set; }

Property Value

TObjectName

UsingExpr 

public virtual TExpression UsingExpr { get; set; }

Property Value

TExpression

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParse(TCustomSqlStatement, ESqlClause)

analyze this node

public override void doParse(TCustomSqlStatement psql, ESqlClause plocation)

Parameters

psql TCustomSqlStatement
plocation ESqlClause

getConstraintName()

valid when OptionType is:

AddConstraintPK, optional

AddConstraintUnique, optional

AddConstraintFK, optional

ModifyConstraint

RenameConstraint

DropConstraintFK

DropConstraintUnique, available in DB2

DropConstraintCheck, available in DB2

DropConstraintIndex, available in DB2

DropConstraintKey, available in DB2

AlterConstraintFK, available in DB2

AlterConstraintCheck, available in DB2 

public virtual TObjectName getConstraintName()

Returns

TObjectName

constraint name

init(object)

Initialize a query tree node.

public override void init(object arg1)

Parameters

arg1 object

init(object, object) 

public override void init(object arg1, object arg2)

Parameters

arg1 object
arg2 object

init(object, object, object) 

public override void init(object arg1, object arg2, object arg3)

Parameters

arg1 object
arg2 object
arg3 object

init(object, object, object, object) 

public override void init(object arg1, object arg2, object arg3, object arg4)

Parameters

arg1 object
arg2 object
arg3 object
arg4 object

setAnyTypeName(TObjectName) 

public void setAnyTypeName(TObjectName n)

Parameters

n TObjectName

setAttributeOptions(List<TAttributeOption>) 

public void setAttributeOptions(List<TAttributeOption> o)

Parameters

o List<TAttributeOption>

setColumnName(TObjectName) 

public void setColumnName(TObjectName on)

Parameters

on TObjectName

setConstraintName(TDummy) 

public virtual void setConstraintName(TDummy pName)

Parameters

pName TDummy

setConstraintName(TObjectName) 

public virtual void setConstraintName(TObjectName constraintName)

Parameters

constraintName TObjectName

setDefaultExpr(TExpression) 

public void setDefaultExpr(TExpression e)

Parameters

e TExpression

setDropRestrictType(EKeyReferenceType) 

public virtual void setDropRestrictType(EKeyReferenceType dropRestrictType)

Parameters

dropRestrictType EKeyReferenceType

setDropRestrictType(TSourceToken) 

public virtual void setDropRestrictType(TSourceToken st)

Parameters

st TSourceToken

setIndexName(TObjectName) 

public void setIndexName(TObjectName n)

Parameters

n TObjectName

setNewCollation(TObjectName) 

public void setNewCollation(TObjectName n)

Parameters

n TObjectName

setNewDataType(TTypeName) 

public void setNewDataType(TTypeName n)

Parameters

n TTypeName

setNewOwnerName(TObjectName) 

public void setNewOwnerName(TObjectName n)

Parameters

n TObjectName

setNewTableName(TObjectName) 

public void setNewTableName(TObjectName n)

Parameters

n TObjectName

setNewTablespaceName(TObjectName) 

public void setNewTablespaceName(TObjectName n)

Parameters

n TObjectName

setParentTable(TObjectName) 

public void setParentTable(TObjectName n)

Parameters

n TObjectName

setRuleName(TObjectName) 

public void setRuleName(TObjectName n)

Parameters

n TObjectName

setStatisticsValue(TConstant) 

public void setStatisticsValue(TConstant c)

Parameters

c TConstant

setStorageName(TObjectName) 

public void setStorageName(TObjectName n)

Parameters

n TObjectName

setTriggerName(TObjectName) 

public void setTriggerName(TObjectName n)

Parameters

n TObjectName

setUsingExpr(TExpression) 

public void setUsingExpr(TExpression e)

Parameters

e TExpression
Edit this page