User defined Data type

  • 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.)

  • 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