Hello there. Thanks very much for taking the time to reply.

OK..........ive taken your code and modified it as such:

IF NOT EXITS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'PRIMARY...