Peter Scott schreef: > Is there a simple way to create a new table with the same structure > as a given one in a *different* database? That means the CREATE > TABLE foo AS SELECT * FROM bar WHERE 1=2 method won't work.
That instruction doesn't guarantee that the new table has the same structure. (for some definition of structure) > I'd need to have two database handles open. > They're both Oracle I suppose the DBD can give you enough information on the table to generate a CREATE statement from that. -- Affijn, Ruud "Gewoon is een tijger."