Re: [sqlite] Select All Tables?

"cstrader" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is there a way to SELECT UNION all of the tables in a database -- > that is to create a big table with rows from each of the individual > tables? I don't see how this is supposed to work, in general. For one thing, tables

[sqlite] Select All Tables?

Is there a way to SELECT UNION all of the tables in a database -- that is to create a big table with rows from each of the individual tables? I understand I can do multiple selects, but the command gets very long if there are a lot of tables. Thanks