[fpc-pascal] Re: RE : RE : Re:SQLDBGetSchemaInfoSQLforindexesetc?
ludo.brands at free.fr
Thu Apr 19 20:42:11 CEST 2012
> > Exactly because indexes and foreign keys have also an owner schema
> > (CONSTRAINT_SCHEMA), I overlooked datadictionary.
> I am not familiar with these terms, so I totally fail to understand
> the first part of your sentence...
> Is there somewhere a reference about 'schema' data ?
Sorry. I have been working on ODBC drivers for a long time and the
Basically, every database object (with some exceptions) belongs to a schema.
So TDDIndexDef and TDDForeignKeyDef should reference an owner. Since
datadictionary isn't a property for these classes, it didn't jump out as an
equivalent for 'schema'.
Some reference docs.
DB2 (db2 cli is the origin of odbc):
SQL92 standard: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
More information about the fpc-pascal