Re: Making a temp table permanent
Hi,
I'm not aware of a way to switch the TEMP table attribute to permanent.
You can:
1) Create the perm. table and copy the data over with:
INSERT INTO perm_table
SELECT * FROM temp_table;
2) Just change your SQL for creating the table so that it is permanent
from the start. You can then just drop the table in the event you
didn't want it around any more.
-Bill
}
} Hi
}
} We are using
}
} select ...
} into temp table_name
}
} What we wish to do is make the temp table permanent?
}
} Thanks
}
} William
}
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com