[fpc-pascal] SQLDB GetSchemaInfoSQL for indexes etc?

[LacaK]

>
> 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
> (stProcedureParams)?
>
>   
See 
http://docwiki.embarcadero.com/VCL/XE2/en/SqlExpr.TCustomSQLDataSet.SetSchemaInfo

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

> I'll implement at least stIndexes for MS SQL Server, perhaps
>   
It will be good do some comparasion tests with DbExpress
(how names results columns , which columns are returned etc.)
 http://docwiki.embarcadero.com/RADStudio/XE2/en/Fetching_Metadata_into_a_dbExpress_Dataset

L.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20120417/97e372ec/attachment.html>