CODEWITHSUNDEEP
sybasealter-table
Anthony Kong
Anthony Kong

Reputation: 40624

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

Hopefully the title has made it quite clear.

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

Upvotes: 5

Views: 21552

Answers (1)

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239646

Modifying the NULL default value of a column:

If you are changing only the NULL default value of a column, you do not need to specify a column's datatype

(Switching the example from the above link):

alter table authors
modify address null

Upvotes: 12

Related Questions