locked
Editing User Defined Data type RRS feed

  • Question

  • Is there an easy way to edit an existing User Defined Data type ? For instance i have a custom data type address of base type nvarchar with a length of 40, I want to increase this custom data types length to 50, is there a way to do it or is it even supported?

    The SQL Server 2005 Mangement Studio does not allow you do it..is there a work around for this?

    Thanks,

    Krishna

    Monday, March 13, 2006 11:13 PM

Answers

  • There is no easy way to do this without dropping and recreating the user-defined data type. You can do this via TSQL. I do not know about the GUI. You might want to ask this question in the SQL Server Tools forum.
    Tuesday, March 14, 2006 12:07 AM

All replies

  • There is no easy way to do this without dropping and recreating the user-defined data type. You can do this via TSQL. I do not know about the GUI. You might want to ask this question in the SQL Server Tools forum.
    Tuesday, March 14, 2006 12:07 AM
  • Thanks, its the same with GUI, its not editable, it just allows us to either delete them and re-create them. Also before deleting them it makes us to remove all references, so its a bit of work..

    Regards,

    Krishna

    Tuesday, March 14, 2006 12:41 AM