> -----Original Message-----
> From: Ann W. Harrison [mailto:aharrison@...]
> Sent: Sábado 9 de Junio de 2001 12:28
> To: IB-Architect@yahoogroups.com; IB-
>
> I missed your reaction to Jim's question -
> do you really want a delete that doesn't fail,
> or a way to define a table without worrying
> about whether it already exists?

While the question was targeted to Jason, I like to point some facts:
- Probably the need to drop a table is to create a new one with the same
name but different structure. Most common case?
- It may be the case also that you want to drop and define it same as before
just because it may be more efficient than deleting all records in the
table. Here I know about a weird latency problem, where at least two people
reported last year that recreating the table as fast as possible (doing drop
and create in an script) caused the new table to have records.
- There may be some tables with fixed structure that are used as helpers for
some complex operations. Maybe the script needs to simply drop them without
caring if they exist or not.
- The idea of morphing a table to create a new one is nice in theory. If it
works in NetfraS, good for it. However, at this time, in FB it's unfeasible
IMHO: the mosquito (pardon, the bird) has today enough trouble altering
metadata to introduce yet another headache.

C.