Hi Martijn,

Yes it's in ISQL. Problem is there are many commands in that script for other tasks, so in case the table exists already, would the whole script fail ?

Thanks again, Nico

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
Upscene Productions

Yahoo! Groups Links

Tekst ingevoegd door Panda Client Shield:

Als het hier gaat om een ongevraagde e-mail (SPAM), klik dan op de volgende link om de e-mail te herclasseren: