> -----Original Message-----
> From: Ann W. Harrison [mailto:aharrison@...]
> Sent: Sábado 9 de Junio de 2001 17:36
>
> That's what I thought. The syntax for RECREATE TABLE is the same as
> the syntax for CREATE TABLE. The difference is that RECREATE will
> delete the previous version of the table if one exists.

Ah, how easy to deal for the developer. The script program won't have to
care about previous instance's existence. It doesn't seem hard to implement
and may be a thing that makes people happy (except JAS, probably).

> The "timing" shouldn't be a problem, though there's a chance that dropping
> and creating in the same transaction is a problem.

That was my first suggestion, but those people found that the only
guaranteed cure was to disconnect and reconnect. I'm trying to convince one
of the developers to post an example; I don't know how to reach the second
person.

> I'm not proposing that RECREATE morph the data - which Jim's UPDATE may
> do - just delete the table if it exists and define a new table.

It was my fault to assume you might be in sync with Jim's proposal, sorry.

C.