Introduction
.NET VERSION
COM VERSION
Supported SQL
Installation
HowTo
Version history
Registration
Using General SQL Parser
Getting Started
How to use join table
Visitor pattern used in General SQL Parser
How to identify DB objects in your sql
How to use expression
Set operation in select statement
Source token and database object
How to refactor sql
Select Statement
From clause
Select list
Where clause
Group by clause
Having clause
Order by clause
Beautify sql and syntax highlighting
Source Token Types
Samples
Check Syntax
Pretty Print
Get sql statements
Get Database Object
Table Rename
XML output of query structure
Visit Join Table
Visit expression
Remove variables in where clause
Analyze script
Build sql from the groud up
Iterate sql parse tree
update to select
Get oracle package name
Symbol Reference
Classes
Common SQL Statement Classes
TAlterSessionStatement Class
TCommitSqlStatement Class
TCommonTableExpression Class
public
ndSelect_with_parens Field
TCreateIndexSqlStatement Class
public
qi_name Field
CreateIndexOptions Property
IndexName Property
IndexTable Property
TCreateTableSqlStatement Class
public
SelectStmt Property
TCreateViewSqlStatement Class
TCustomSqlStatement Class
public
cte Field
fcRoot Field
IsParsed Field
isSemiColonEnded Field
SemiColonEnded Field
SourceTokenList Field
SqlStatementType Field
Table Field
DatabaseTokens Property
ErrorCount Property
ErrorMessages Property
Fields Property
FirstToken Property
FunctionTokens Property
IndexTokens Property
InspectedDBObjs Property
LastToken Property
OnBindVar Event
OnSqlVar Event
PackageTokens Property
Params Property
RawSqlText Property
Root Property
SchemaTokens Property
SequenceTokens Property
ServerTokens Property
SqlDesc Property
SqlVars Property
SyntaxErrors Property
Tables Property
TableTokens Property
TriggerTokens Property
ViewTokens Property
WhereClause Property
WhereClauseAsPrettyText Property
WhereClauseText Property
AddTokenToList Method
CheckAsTextAfterRebuild Method
CheckSyntax Method
CopyErrorMsg Method
Create Constructor
GetFieldsFromExpr Method
GetRawSqlTextBeforeSemiColon Method
GetRawSqlTextWithoutCmt Method
GetTextFromParseTree Method
InspectDBObject Method
Iterate Method
Parse Method
ParseErrorMessageHandle Method
ReBuildSql Method
TDeleteSqlStatement Class
public
_IsUsing Field
AssignmentClauseAsPrettyText Property
AssignmentClauseText Property
DeletedTables Property
DeletedTableText Property
FromClauseAsPrettyText Property
FromClauseAsText Property
IncludeColumns Property
IncludeColumnsText Property
IsHasFrom Property
IsolationClause Property
IsolationClauseText Property
JoinTables Property
limitClause Property
limitclauseText Property
OutputClause Property
RefTableText Property
ReturningClause Property
ReturningClauseText Property
SortClause Property
SortClauseText Property
TableText Property
TopClause Property
TDropIndexSqlStatement Class
TDropTableSqlStatement Class
TDropViewSqlStatement Class
TInsertSqlStatement Class
public
MultiValues Field
SetColumns Field
subquery Field
Values Field
WithInto Field
MultiValueListText Property
MySQLSetColumnsAsPrettyText Property
MySQLSetColumnsText Property
ReturningClause Property
ReturningClauseText Property
TopClause Property
ValueListText Property
GetMultiValuelistAsPrettyText Method
GetValueListAsPrettyText Method
TMergeSqlStatement Class
TSelectSqlStatement Class
public
SelectSetType Field
JoinTables Property
LeftStmt Property
RightStmt Property
ValueClause Property
TUpdateSqlStatement Class
public
JoinTables Property
UpdateTables Property
Raw node of Common SQL Statement
TLz_alterTableStmt Class
TLz_Common_table_expression Class
TLz_CreateDatabaseStmt Class
TLz_CreateTableStmt Class
TLz_CreateViewSqlStatement Class
TLz_DeleteStmt Class
TLz_DropIndexSqlStatement Class
TLz_DropTableStmt Class
TLz_DropViewSqlStatement Class
TLz_MergeStmt Class
TLz_SelectStmt Class
SQL Server Related Classes
Classes
TMssqlCreateFunction Class
public
blockstmt Field
BodyType Field
createoralter Field
functionname Field
functiontype Field
procedure_parameters_declaration Field
returnstmt Field
returnTableVar Field
returntype Field
TMssqlCreateProcedure Class
public
createoralter Field
groupnumber Field
procedure_parameters_declaration Field
procedurename Field
SqlStatements Property
TMssqlCreateTrigger Class
public
OnTableName Field
TriggerName Field
SqlStatements Property
TableToken Property
TLz_MssqlExecParam Class
public
_ndParamValue Field
_stOutput Field
_stParamVar Field
Raw node of SQL Server
_TMssql_declare_var Class
public
getDatatype Method
getVariableName Method
_TMssql_opt_declaration_expr Class
public
_expr Field
_TMssql_ParameterDecl Class
public
_datatype Field
_opt_declaration_expr Field
_parameter_name Field
Oracle Related Classes
TSqlplusCmdStatement Class
Classes
TLzPlsql_Package Class
TLzPlsql_ProcedureSpecStmt Class
TLzPlsql_SubProgram Class
TLzPlsql_TableTypeDefStmt Class
TLzPlsql_Trigger Class
DB2 Related Classes
MySQL Related Classes
TAccessParameters Class
public
getVariables Method
TCustomGSqlParser Class
public
AfterTokenlizer Event
DbVendor Property
DelimiterChar Property
ErrorCount Property
ErrorMessages Property
FormattedSqlfilename Property
FormattedSqlText Property
IsPPDifferenceText Property
IsPPError Property
IsPPException Property
IsProcessSubstitutionVar Property
IsQMarkToIdent Property
KeepSqlWhenPp Property
Lexer Property
OnBindVar Event
OnFieldToken Event
OnGetRawSqlStatement Event
OnParserToken Event
OnParserTokenError Event
OnSqlVar Event
OnSubstitutionVar Event
OnTableToken Event
Parser Property
SourceTokenList Property
Sqlfilename Property
SqlStatements Property
SqlText Property
SyntaxErrors Property
XmlText Property
CheckIterate Method
CheckSyntax Method
Create Constructor
GetRawSqlStatements Method
GetTextFromParseTree Method
On_ParserTokenErrorKeywordToIdent Method
Parse Method
ParseSqlStatements Method
PrettyPrint Method
SQLTextToTokenList Method
ValidatePPText Method
TGSqlParser Class
TLz_AliasClause Class
public
_alias Field
_aliastoken Field
_stAs Field
_withas Field
aliastext Property
TLz_AnalyticFunction Class
TLz_Attr Class
public
_dblink Field
attrs Field
relname Field
ColumnNameToken Property
DatabaseNameToken Property
firstname Property
lastname Property
ObjectNameToken Property
SchemaNameToken Property
ServerNameToken Property
TLz_CastArg Class
TLz_Const Class
public
valtoken Field
valtype Field
TLz_DummyNode Class
TLz_FuncCall Class
public
_analyticFunction Field
_stArgPrefix Field
args Field
funcname Property
FunctionName Property
FunctionPrefix Property
TLz_Ident Class
TLz_InsertStmt Class
TLz_JoinExpr Class
public
_join_hint Field
_join_type Field
jointype Field
larg Field
quals Field
rarg Field
TLz_JoinQual Class
public
expr Field
joinqualtype Field
namelist Field
TLz_List Class
public
Iterate Method
TLz_Node Class
public
AsPrettyText Property
AsText Property
AsXmlText Property
NodeDummyTag Property
Nodetype Property
RawNode Property
TLz_ResTarget Class
TLz_SortGroupBy Class
TLz_TableRef Class
TLz_TypeName Class
public
ft Field
_stTypename Property
_stTypename2 Property
TLz_UpdateStmt Class
TLz_ValueClause Class
TLzColumnDef Class
public
_ndExpr Field
ColumnName Field
RawColumnConstraintList Field
ColumnConstraintList Property
ColumnType Property
TLzConstraint Class
public
_keyword Field
_name Field
ConstraintType Field
RefClause Property
TLzConstraintList Class
TLzConstraintRefClause Class
public
_column_listnode Field
_stReferences Field
q_name Field
KeyAction Property
KeyDeleteReference Property
KeyMatch Property
KeyUpdateReference Property
TLzCTE Class
TLzCustomExpression Class
public
groupcompareType Field
IsParseAfterSetValue Field
lexpr Field
oper Field
rexpr Field
sub_type Field
FieldTokens Property
TableTokens Property
GetInvolvedDbObjects Method
InOrderTraverse Method
ParseAsText Method
PostOrderTraverse Method
PreOrderTraverse Method
TLzDBObject Class
public
ChildDBObjects Property
ObjectName Property
ObjectPrefix Property
ObjectToken Property
ObjectType Property
TokensInScript Property
TLzDBObjectList Class
TLzField Class
public
aliasclause Field
ColumnConstraints Field
ColumnName Field
ComputedColumnAsToken Field
ComputedColumnExpr Field
Constraints Field
FieldDataType Field
FieldExpr Field
FieldNameWidth Field
FieldType Field
possiabletables Field
SubQuery Field
FieldAlias Property
FieldDesc Property
FieldFullname Property
FieldName Property
FieldNameLen Property
FieldPrefix Property
FieldToken Property
IsHasAs Property
TLzFieldList Class
TLzFmtOpt Class
TLzJoin Class
public
JoinItems Property
JoinJoin Property
JoinTable Property
JoinTableType Property
RefreshOrderOfJoinItem Method
TLzJoinItem Class
public
JoinItemJoin Property
JoinItemTable Property
JoinItemTableType Property
JoinQual Property
JoinQualType Property
JoinType Property
TLzJoinItemList Class
TLzJoinList Class
TLzNode Class
TLzStatementList Class
TLzTable Class
public
containfreetable Field
dctr Field
DmlStmt Field
FlashbackClause Field
isfunction Field
IsTable Field
mshintlist Field
OnlyOuterToken Field
openrowset Field
openxml Field
pivottable Field
PxGranule Field
SubQuery Field
TableAttr Field
TableExpr Field
TableSample Field
TableType Field
DbLink Property
DisplayName Property
Fields Property
IsHasAs Property
IsPhysicalTable Property
TableAlias Property
TableDesc Property
TableFullname Property
TableName Property
TableOptions Property
TablePrefix Property
TLzTableList Class
TLzTopClause Class
TLzValue Class
TLzValueList Class
TSourceToken Class
public
ChildToken Field
CodeSource Field
Container Field
DBObjType Field
ParentToken Field
RelatedSubquery Field
RelatedToken Field
TokenCode Field
TokenStatus Field
TokenType Field
XPosition Field
YPosition Field
RelatedTokens Property
TSourceTokenList Class
Structs, Records, Enums
TDBObjType Enumeration
TDbVendor Enumeration
TSyntaxError Record
Types
TLzExprVisitFunc Type
Constants
LBWindows Constant
op Constant
Variables
gFmtOpt Variable