Re: Create Temporary Table with same name as non-temporary table

[Alejandro Diaz]

tack so mycket Micke!

The "like" with same table names was the problem. I finally did the same create temporary table clause but putting a different temporary table name. Then with alter table renamed the temporary table name to the main one.

Something like this:
create temporary table menuprincipal_temp like menuprincipal
alter table menuprincipal_temp rename menuprincipal



Thanks,
Alex (Barcelona, Spain)