July 12, 2004 at 3:02 am
Is there any way to alter the definition of a User defined datatype that is already referenced in tables? For example, what can be done user defined datatype with the definition "Char(5)" needs to be increased to "Char(10)"? (Note: I don't want to remove the references to the datatypes from the tables since that is referenced in many tables.)
July 12, 2004 at 5:31 am
Unfortunately this is one of the problems with user defined datatypes.
You can update them, but they don't affect existing definitions within tables. They act as a template at the time of creation.
If you look in the systypes table within a database you will see that they are actually aliases of built-in datatypes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy