General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I assume realtable is part of a database.
To keep the attributes and references of the real table at runtime, I would not replace it.
May be:
select realtable
zap
append from temptable
works for you.
If you don't care about references and attributes of the realtable
select * from temptable into table realtable data abc
may work either.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only