Sybase / ALTER TABLE: how to turn an existing column from non-nullable to nullable?

Question

I hope that this name has become clear.

I would like to see an example of an alter table statement that can modify an existing non-NULL column in a Sybase table to nullify.

+5

Anthony kong Jul 6 '11 at 8:17

1 answer

Damien_The_Unbeliever · Accepted Answer · 2011-07-06T08:34:09+0000

If you only change the default NULL value for a column, you do not need to specify the column data type

(Switching an example from the above link):

alter table authors
modify address null