You are here: Symbol Reference > Classes > TLzTable Class > public
ContentsIndexHome
PreviousUpNext
public

The public members of the TLzTable class are listed here.

Fields
Field 
Description 

Points to CONTAINSTABLE of Mssql. 
dctr 

Data change table reference clause of DB2. 

If data source is data change table clause of DB2, the DmlStmt is insert/delete/update statement. 

Flashback clause for table in Oracle. 

This data source is derived from a function. 

Data source is a table source like this:
table ( subquery )
or
table ( expression ) 

Points to table hints of mssql. 

Only keyword in syntax like this in DB2.

Only ( qualified name ) 

Data source is open row set of ms sql server. 
Data source is open xml of ms sql server. 

Data source is pivot and unpivot clause of ms sql server. 

Px Granule Clause of data source in Oracle. 
TableType is lttSubquery, this property points to an select statement which type is TSelectSqlStatement

TableType is lttAttr, this property points to a qualified name which type is TLz_Attr
TableType is lttExpr, this property points to an expression which type is TLzCustomExpression

Table sample clause. 

Type of this data source. 
Properties
Property 
Description 

Database link of this table. 
Table alias if any, or table name if table alias doesn't exits. 

If table in create table statement, then Fields contain columns information in create table statement. 

Is as keyword in table alias. 

Check is this table a derived table of physical table. 

Table alias in string. Doesn't contain as keyword. 

Full table name includes table alias. Same as AsText property. 

Full table name which includes table prefix(usually, it's server.database.schema). 

Only table name, no table prefix, no table alias. 

MySQL table options. 

Prefix of table, usually, it's server.database.schema 
Gudu software http://www.sqlparser.com
Send comments about this topic.