[fpc-pascal] SQLDB GetSchemaInfoSQL for indexes etc?

Reinier Olislagers reinierolislagers at gmail.com
Tue Apr 17 11:22:27 CEST 2012

On 17-4-2012 10:41, michael.vancanneyt at wisa.be wrote:
> On Tue, 17 Apr 2012, Reinier Olislagers wrote:
>> In sqldb, this:
>> 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)

Thanks Michael.
Function signature is
GetSchemaInfoSQL(SchemaType : TSchemaType; SchemaObjectName,
SchemaPattern : string) : string;
... assuming SchemaObjectName would be used similar to the existing code
and would specify table name (stIndexes)/stored proc name

I believe package names are unique within dbs in Oracle (don't know
Firebird, IIRC, that's planned for the upcoming 3.0, right?), so no
parameters required for stPackages?

SchemaPattern doesn't seem to be used; perhaps meant as some kind of
filter to limit the results?

I'll implement at least stIndexes for MS SQL Server, perhaps
ProcedureParams as well..
Later on the same for Sybase, perhaps Firebird.


More information about the fpc-pascal mailing list