Data.SqlExpr.TSQLSchemaInfo.FType
Delphi
FType: TSchemaType;
C++
TSchemaType FType;
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| field | public | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLSchemaInfo |
Description
Identifies the type of information of the dataset.
FType specifies the type of information of the dataset. FType is a TSchemaType and can take one of the values listed in the following table:
| Value | Description |
|---|---|
|
stNoSchema |
No schema information. When FType is stNoSchema, the SQL dataset is populated with the results of its query or stored procedure rather than metadata from the server. |
|
stTables |
Information about all the data tables on the database server that match the criteria specified by the SQL connection's TableScope property. |
|
stSysTables |
Information about all of the system tables on the database server. Not all servers use system tables to store metadata. Requesting a list of system tables from a server that does not use them results in an empty dataset. |
|
stProcedures |
Information about all of the stored procedures on the database server. |
|
stColumns |
Information about all of the columns (fields) in a specified table. |
|
stProcedureParams |
Information about all of the parameters of a specified stored procedure. |
|
stIndexes |
Information about all of the indexes defined for a specified table. |
|
stPackages |
Information about all of the packages defined on the database server (Oracle only). |