I am in a situation where I have a database consisting of approx 35 tables. I have just changed a table name which meant I had to trawl through all the code and change all the instances in the SQL code. What would be the best way to store all the table names in one place so "IF" I have to change one again, I only have to do it the once.

I was thinking some sort of enumerated type?

Thanks