You are here: Symbol Reference > Classes > Common SQL Statement Classes
ContentsIndexHome
PreviousUpNext
Common SQL Statement Classes
Classes
Class 
Description 

Class used to represent alter session sql statement. 
Class used to represent commit sql statement. 

Class represents Common Table Expression. 

Class represents create index statement.
You can obtain column information in Fields property. 

Class represents create table statement. 

Class represents create view statement. 

This is the base class of all classes that represent a sql statement. 
Class represents delete statement.

How to find table(s) in delete statement class?

All tables can be found in Tables property. But you can
fetch specific table from the following different properties.

Table, DeletedTables, JoinTables

[MySQL]
Delete tablelist from tablelist
First tablelist is in DeletedTables, and second tablelist is in JoinTables

[Sql Server]
Delete table from tablelist
First table is in Table property, and tablelist is in JoinTables.

[Oracle,DB2]
Delete table
This table is in Table property. 
Class represents drop index statement. 

Class represents drop table statement.

Table information can be fetched from Tables[0] 

Class represents drop view statement 

Class represents insert statement.

table name of insert statement can be found in Table property.

values can be found in Fields property. 

Represents merge statement. 
Represents select sql statement. 

Class represents update statement.

If there is only one table in update clause, check this table in Table property.

If there is more than one table in update clause, check these tables in UpdateTables properties.

If there is a from clause in update statement, check those
tables in from clause in JoinTables property.

Set clause information can be found in Fields property. 
Modules
Module 
Description 
 
Gudu software http://www.sqlparser.com
Send comments about this topic.