[fpc-pascal] SQLDB GetSchemaInfoSQL for indexes etc?

LacaK lacak at zoznam.sk
Tue Apr 17 12:45:34 CEST 2012

>> type TSchemaType = (stNoSchema, stTables, stSysTables, stProcedures,
>> stColumns, stProcedureParams, stIndexes, stPackages);
>> is used in the GetSchemaInfoSQL function:
>> Does anybody know what stIndexes, stProcedureParams and stPackages
>> should return and when they would be used?
> stIndexes: get a list of indexes from a table.
> stPRocedureParams: get the parameters of a stored procedure
> stPackages: list packages (Oracle and Firebird)
See also http://docwiki.embarcadero.com/VCL/en/SqlExpr.TSchemaType
Where also stUserNames is added (may be, that this would be good add 
also in FPC)

And Delphi supports also (beside GetTableNames, GetProcedureNames, 
 and others like GetPackageNames, GetProcedureParams (where 
implementation across SQL-connectors may be problematic)


More information about the fpc-pascal mailing list