Post reply

Changing the underlaying datatype of a user defined datatype

  • April 27, 2004 at 8:20 am

    #82742

    Hi,

    I need to change the underlaying datatype of a user defined datatype (udtMyType) from varchar(5) to varchar(10).

    I changed the name of udtMyType to udtOldMyType and created a new udtNewMyType with varchar(10).

    I updated all tables to use the new udtNewMyType.

    Now I want to delete the old udtOldMyType, however SQL says the old udtOldMyType is still being used. Obviously this is the case for all views depending on the changed tables.

    Now, does a quick method exists to update all references to udtOldMyType to the new udtNewMyType. Can I update the systypes-table?

    Thanks,

    R. Versteeg.

  • April 27, 2004 at 2:16 pm

    #504393

    sysdepends may give you the inventory.

    sp_refreshview @viewname =  'viewname'  may perform what you are looking for

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • April 29, 2004 at 1:08 am

    #504608

    Thanks, sp_refreshview worked fine.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply