Skip to content

    TSchemaType

    Schema type to retrieve.

    Declaration

    Source position: sqltypes.pp line 32

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

    Values

    Value Description
    stNoSchema No schema.
    stTables User Tables in database.
    stSysTables System tables in database.
    stProcedures Stored procedures in database.
    stColumns Columns in a table.
    stProcedureParams Parameters for a stored procedure.
    stIndexes Indexes for a table.
    stPackages Packages (for databases that support them).
    stSchemata List of schemas in database(s) (for databases that support them).
    stSequences Sequences (for databases that support them).

    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

    Name Description
    TCustomSQLQuery.SetSchemaInfo SetSchemaInfo prepares the dataset to retrieve schema info.
    Retrieving Schema Information Retrieving Schema Information.