At 10:33 AM 7/03/2004 +0000, you wrote:

>-
>Thanks, that worked perfectly.
>If Firebird could create and associate Domain's based on source table
>in 'insert into mytable2 select * from mytable1' that would be
>very convenient especially for people migrating from other databases
>or people who are creating large number of tables.
>Maybe this is a wishlist candidate.

Doubtful, under the present relational model. Why stuff the engine full of
capabilities that are only used rarely? That's what we have all those cool
third-party tools for...

Now, an object-relational model, there's another story... <g>

Table.Clone, anyone?

/h