Help in changing a UDD from not null to null

• vikramchander90

  Ten Centuries

  Points: 1093

  More actions

  March 30, 2021 at 7:47 pm

  #3863734

  Hi,

  Any re-commendations on how it is possible to change udd from not null to nullable type. I need to change around 300 UDD's and that udd is reffered by around 40-50 sps and 90-100 tables. Only few tables have data. This is causing problems when new column is getting added to a set of tables. I only need to change default nullable from no to yes. Length and data type is fine. Any suggestions please.

  • This topic was modified 3 years, 8 months ago by  vikramchander90.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  March 31, 2021 at 8:10 pm

  #3864145

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.