>Ludo here I do not understand what do you want to say. may be, that my english is not so good ;-) >Can you explain please what is your proposal regarding to stIndexes ?
stIndexes is currently not implemented: keep it that way (or drop it) but add and implement stTableConstraints, stReferentialConstraints, stKeyColumnUsage, stConstraintColumnUsage and stConstraintTableUsage. And why not some other missing information_schema views like 'views' or 'schemata'. Delphi compatibility? Delphi adodb defines and implements the following: type TSchemaInfo = (siAsserts, siCatalogs, siCharacterSets, siCollations, siColumns, siCheckConstraints, siConstraintColumnUsage, siConstraintTableUsage, siKeyColumnUsage, siReferentialConstraints, siTableConstraints, siColumnsDomainUsage, siIndexes, siColumnPrivileges, siTablePrivileges, siUsagePrivileges, siProcedures, siSchemata, siSQLLanguages, siStatistics, siTables, siTranslations, siProviderTypes, siViews, siViewColumnUsage, siViewTableUsage, siProcedureParameters, siForeignKeys, siPrimaryKeys, siProcedureColumns); Ludo _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal