SQL Server Performance

Changing User Defined Data Type

Discussion in 'T-SQL Performance Tuning for Developers' started by gaurav_bindlish, Apr 3, 2003.

  1. gaurav_bindlish New Member

    How can I change the user defined datatype used in my SQL Server? I mean there is always an option of altering the objects in which the user-defined data type has been used and then dropping and creating the datatype again and finally again altering the objects that used the user defined data type. But that is going to be a painfully long process. Is there any other way to do it?

    Gaurav
    gaurav_bindlish, Apr 3, 2003
    #2

  2. satya Moderator

    Refer to books online for SP_RENAME.

    _________
    Satya SKJ
    satya, Apr 3, 2003
    #2

  3. gaurav_bindlish New Member

    I guess i didn't make my question clear. I want to change the data type of the user defined data-type. Say FirstName from Char(15) to Char(20). sp_rename lets me change the name but not the type.

    Gaurav
    gaurav_bindlish, Apr 6, 2003
    #2

  4. satya Moderator

    I haven't seen any route to do so, all the times for such change I was deleting and adding the UDD again.

    _________
    Satya SKJ
    satya, Apr 6, 2003
    #2

Share This Page