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.

_______________________________________________
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Reply via email to