Sign in Join
FPDoc Onlineexperiment

TSchemaType enumeration

In unit SQLTypes

Schema type to retrieve.

Declaration

pascal
TSchemaType = (stNoSchema,stTables,stSysTables,stProcedures,stColumns,
 stProcedureParams,stIndexes,stPackages,stSchemata,
 stSequences)

Description

TSchemaType describes which schema information to retrieve in the TCustomSQLQuery.SetSchemaInfo call. Depending on its value, the result set of the dataset will have different fields, describing the requested schema data. The result data will always have the same structure.

See also

Values

stNoSchemaNo schema.
stTablesUser Tables in database.
stSysTablesSystem tables in database.
stProceduresStored procedures in database.
stColumnsColumns in a table.
stProcedureParamsParameters for a stored procedure.
stIndexesIndexes for a table.
stPackagesPackages (for databases that support them).
stSchemataList of schemas in database(s) (for databases that support them).
stSequencesSequences (for databases that support them).

An experiment, built from development snapshots. Not the official Free Pascal or Lazarus documentation.