Table and User Defined Type with same Name
So I just found out that I really messed up!
I have managed to create several user defined data types and several tables in the same database with the same name.
I wanted to change the data type of one of my UDDT's and I found some strange behaviour. For one, If I rename the UDDT using EM, it actually renames my table!
Has anyone run into this before? How would I rename my UDDT's without causing big problems with my tables?