> Scripts are just batches of statements. If you are using a third-party tool that has a scripting interface, make sure you are able to control what happens to later statements if exceptions occur in earlier ones. A bad line in a script doesn't stop the script from continuing to execute! The Firebird engine itself doesn't know it is executing a script. ;-)

The point is that CREATE TABLE should fail always if the table have 2 rows with the same name.

The table was like this:

(some fields)
"Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 4096,
(some other fields)
"Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 8192
(end of definition)

Both fields inside quotes. I tested again:

CREATE TABLE "Demo" (
"Codigo" INTEGER NOT NULL,
"Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 8192,
"Nombre" VARCHAR(50) NOT NULL COLLATE PXW_SPAN,
"Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 4096
);

You will have only one field named Observaciones... then try this:

ALTER TABLE "Demo"
DROP "Observaciones";

You will get an error.

Using latest firebird 2.1.1.17910

Regards,
Mauro.