How to alter User Defined Data Types

• sundareswar

  Grasshopper

  Points: 24

  More actions

  December 21, 2001 at 2:42 am

  #57575

  Hello,

  I want to alter the width/type of a User Defined Data

  Type. I searched for the same. Everybody suggests to drop

  the type and recreate the same. Since its in the

  Production and lot of dependent objects are there. It will

  be very difficult to alter each and every object.

  Is there any way to do the same in SQL 7 or SQL 2000. Or

  is there any hidden extended procedures for the same.

  Your suggestions and solutions are highly appreciated.

  Thanks in Advance!

  Regards

  Sundar

  
  Sundareswar

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  December 21, 2001 at 8:53 am

  #421363

  Not that I know of. I think you would have to remove all references to this before you can change it.

  Alternatively, you can create a new datatype and move all objects, but that will require work.

  Steve Jones

  steve@dkranch.net