Re: Making a temp table permanent
William Hayman wrote:
>
> Hi
>
> We are using
>
> select ...
> into temp table_name>
> What we wish to do is make the temp table permanent?
Change that to an explicit CREATE TABLE newtable(...) followed by
INSERT INTO newtable SELECT ... FROM oldtable;
There is no way to duplicate the schema of a table into a permanent
table.
Art S. Kagel