Subject Re: [firebird-support] create table as select
Author Thomas Steinmaurer
>> Recently I have used the feature in MS SQL for ordinary DBA work, and
>> found it very useful. I created a lot of tables and dropped none. :-)
>> Nothing that couldn't be done by good admin/client tools, but having
>> the feature in SQL is just handy.
> It is handy but it is against relation theory. Normalization! Why
> you can want to have two tables in a database with the same structure
> and the same data?..

Being involved in some Oracle projects lately, I found the CREATE TABLE
AS statement extremely useful in converting external tables (with a lot
of fields!) into "internal" tables, stepping forward with creating
indices ... on the internal tables then.