[fpc-pascal] SQLDB GetSchemaInfoSQL for indexes etc?

[LacaK]

>>
>> 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, 
GetFieldNames)
 GetIndexNames  
http://docwiki.embarcadero.com/VCL/XE2/en/SqlExpr.TSQLConnection.GetIndexNames
 and others like GetPackageNames, GetProcedureParams (where 
implementation across SQL-connectors may be problematic)

L.