Post reply

User Defined Data Type and varchar(max)

  • May 27, 2008 at 4:47 am

    #191504

    I want to change some existing columns from text to varchar(max). Our standard is to use user defined data tupes, but Management Studio won't let me create a UDT with a data type of varchar(max). Any ideas? Or do I just have to break our standard (leaving them as text isn't really an option given the benefits of varchar(max) over text)

    Thanks

    Martin Davies

  • May 27, 2008 at 4:58 am

    #820449

    OK, I fixed it myself. It can be scripted, even though Management Studio won't let you do it.

    CREATE TYPE [TEST_VMAX] FROM [varchar] (max) NOT NULL

    Martin

    martin (5/27/2008)

    I want to change some existing columns from text to varchar(max). Our standard is to use user defined data tupes, but Management Studio won't let me create a UDT with a data type of varchar(max). Any ideas? Or do I just have to break our standard (leaving them as text isn't really an option given the benefits of varchar(max) over text)

    Thanks

    Martin Davies

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

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