0

I need to allow nulls in a column, but I don't know its data type. In oracle its possible to do this:

alter table MyTable modify MyField null;

the SQL server homologous statement requires the data type (in this example INT):

alter table MyTable alter column MyField int null;

Is there a way to do it like Oracle does?. The idea is not to have to go to the data dictionary to consult the types and build the sentence

Thanks,

GatoSoft
  • 106
  • 1
  • 3
  • 1
    Short answer - there is no similar shortcut to altering a column in this manner. – SMor May 07 '20 at 15:15
  • Can you please translate the title to English? stackoverflow.com is an English only site. – TT. May 07 '20 at 16:13
  • I can't editing post: tittle syas: "Altering a column, to change "null" to "not null", when the data type is not known" – GatoSoft May 07 '20 at 16:29

0 Answers0