At 10/05/2004 13:12, you wrote:

>At 11:51 AM 10/05/2004 +0200, Blas Rodriguez Somoza wrote:
>
> > >A more practical compare list could be done with sql 1999
> > >example:
> > >"Firebird has full SQL 92 Entry Level 1 Support and implements most of
> > >the SQL-99 standard, plus some very useful additions."
> >
> >To implement SQL92 Entry level the database must support schemas (create
> >schema etc) and FB doesn't.
>
>Sure it does.
> Try this:
>
>CREATE SCHEMA 'LOCALHOST:/opt/Firebird/examples/MySchema.fdb';

The FB create schema syntax is not the sql92 one. At least the
AUTHORIZATION keyword is not here.

<schema definition> ::=
CREATE SCHEMA <schema name clause>
[ <schema character set specification> ]
[ <schema element>... ]

<schema name clause> ::=
<schema name>
| AUTHORIZATION <schema authorization identifier>
| <schema name> AUTHORIZATION <schema authorization identifier>

Anyway if I'm not wrong FB don't allow qualified table names which are
needed to support schemas according to SQL92.

<table name> ::=
<qualified name>
| <qualified local table name>

<qualified name> ::=
[ <schema name> <period> ] <qualified identifier>

>Helen

Regards
Blas Rodriguez Somoza