The public members of the TLzTable class are listed here.
Field |
Description |
Points to CONTAINSTABLE of Mssql. | |
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 lttExpr, this property points to an expression which type is TLzCustomExpression. | |
Table sample clause. | |
Type of this data source. |
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.
|