|Subject||Re: [firebird-support] create table as select|
>> Recently I have used the feature in MS SQL for ordinary DBA work, andBeing involved in some Oracle projects lately, I found the CREATE TABLE
>> 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?..
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.