Changing User defined data types

• mike 57299

  SSCrazy

  Points: 2529

  More actions

  January 30, 2011 at 4:45 pm

  #230919

  Hi all...

  Created this user defined data type:

  CREATE TYPE [dbo].[address] FROM [char](30) NOT NULL

  GO

  It is used in my address table and order table. Now I want to change it to char(40). How do I do it? Can I do it? I can't drop it because it being referenced. If I alter the address table, I loose the link to the user defined data type.

  TIA,

  Mike

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  January 30, 2011 at 5:20 pm

  #1280220

  Have you tried.

  1. In a NON production db opened the table with SSMS ... click in the data type column for the row with the address type, select CHAR(40)

  Now with my simple table and not many rows it worked for me ... again try it in your situation in a NON production DB.

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]