[fpc-pascal] Re: RE : RE : Re: SQLDB GetSchemaInfoSQLforindexesetc?

[Michael Van Canneyt]

On Thu, 19 Apr 2012, Ludo Brands wrote:

>>> There are other databases (mssql, oracle) where it is
>> difficult to not
>>> use schemas. So even when not using the word 'schema' the concept
>>> should be represented somewhere.
>>
>> Ehm, the datadictionary is the schema ?
>>
>> Unless I misunderstand the meaning of schema :-)
>>
>
> Aha. That's what you get when not adhering to standards ;)

Touché :)

>
> Schemas "own" more objects than just Tables, Sequences and Domains. So I
> wouldn't have guessed that one.

Correct. fpDatadict is a work in progress.

I use tables, sequences, domains, indexes and foreign keys.

I have not had the need for procedures, triggers and views yet.

Michael.