Thanks everyone for your responses, nice to know its not going to break anything further down the line (replication, indexed views etc).Would have meant quite a bit of pain changing...

Thanks bcronce,

its not quite as dire as what you found, the db looks about 4th normal with composite key tables joining where necessary. I can see why the dev had...