How long do a county court judgment last for?

I AM WELL INFORMED THAT AFTER 6 YEARS THE CCJ IS REMOVED FROM THEIR FILES.