Re: Removing duplicate rows

> As the table definitions get updated frequently, I'd like to put in my
> script to create the table as a copy of the existing 'real' table. I'm
> assuming "create table as" would be what I need to use, but what would I
> use as the select sql - i.e. how do I use select to pull the definition of
> a table.

The create statement allows you to copy a table structure, including or
excluding constraints.
For inclusion and exclusion effects, please read the manual info related
with the 'like' clause of the 'create table' statement.

Ex.:
create temporary table mytesttable (like mymaintable excluding constraints
excluding defaults);

Regards,

Hélder M. Vieira