"Zsolt Koppany" <com> wrote in message
Yes, using the CREATE TABLE AS syntax. These are Materialized Query Tables,
unless the DEFINITION ONLY option is specified, in which case the table is
created without any data.
You can also use CREATE TABLE LIKE... if the new table is exactly like the
See the SQL Reference Vol 2 manual (version 7 only has one volume).