Re: How do add primary key contraint on existing table?

> However I do also think it's in 7.2 or possibly even earlier where you > can temporarily turn off creation of index data while loading your > table. That should also work. Yes. Try the set object mode commands such as SET INDEXES FOR table DISABLED before the load and then enable afterwards. This is is version 7.1. I haven't tried it for this specific problem but it's great for loads of non-unique data with the set violations commands. Is everything in the world an object now? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281