[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'sqldb' (#fcl)

TSchemaType

Schema type to retrieve

Declaration

Source position: sqldb.pp line 26

type TSchemaType = (

  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)

  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

RetrievingSchemaInformation

  

Retrieving Schema Information

TCustomSQLQuery.SetSchemaInfo

  

SetSchemaInfo prepares the dataset to retrieve schema info.


Documentation generated on: Nov 14 2015