Hi Nico,

> Even when I only paste the create table without the if statement it

generates the same error. The problem is : I have to send a script to a
customer to check if a table exists and in case not, it has to be created.

>

Run the CREATE TABLE - if the table exists, it will fail.

> Any idea for a better command ?

With what do you run this? ISQL? If so, make sure you're connected to a
database before doing anything else. It seems it barks on that first.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com