Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my script I first load a table using:
[Table_A]:
Load
field1,
field2,
...
fieldN
from [Path_to_my_excel];
Later I have create a temporary table, let's say, TEMP_TABLE, from [Table_A] and then join TEMP_TABLE with another table.
The result joining table, TEMP_TABLE, has the same columns as [Table_A] but now what I want is to copy entire temporary table TEMP_TABLE into [Table_A], but not append to it, I mean, I want to remove all the records from [Table_A] and copy to [Table_A] the new records from temporary table TEMP_TABLE.
So how to copy all the records from TEMP_TABLE into [Table_A] (not keeping existing [Table_A] records)?
Tony,
drop table Table_A;
RENAME TEMP_TABLE to Table_A;
Tony,
drop table Table_A;
RENAME TEMP_TABLE to Table_A;
How about Dropping Table_A and renaming TEMP_TABLE to Table_A whenever you have the TEMP_TABLE ready to be called Table_A
[Table_A]:
Load
field1,
field2,
...
fieldN
from [Path_to_my_excel];
.
.
.
DROP Table Table_A;
RENAME Table TEMP_TABLE to Table_A;