The error is "Invalid CREATE, CONNECT or DROP DATABASE syntax", i.e.
it is complaining about your database not one single table.

Are you sure you are connected to the database before trying to create
this table?

HTH,
Set

--- In firebird-support@yahoogroups.com, Nico Callewaert wrote:
> Hi,
>
> I don't know what's wrong with this script, but it generates a
"Invalid CREATE, CONNECT or DROP DATABASE syntax" :
>
> IF (SELECT RDB$RELATION_NAME
> FROM RDB$RELATIONS
> WHERE RDB$RELATION_NAME = 'TYPES') IS NULL THEN
> CREATE TABLE TYPES (
> T_CODE VARCHAR( 5 ) NOT NULL PRIMARY KEY,
> T_OMSCHR VARCHAR( 40 ))
>
>
> Any idea ?
>
> Thanks a lot,
>
> Nico