Why would you need an FK on a temp table? FKs are for data integrity protection, to prevent the deletion of a PK where a matching FK exists. It is illogical to use PK/FK protection on temp tables as they are not permanent data.
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Monday, March 15, 2010 4:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Temp Tables Hi Can you have a FK on a Temp Table? ALTER TABLE `tran_spd` ADD FOREIGN KEY ( `treat_dr` ) + REFERENCES `DRINFO` I keep getting an error "referenced table does not exists.." Thanks Marc
