Posted on 2012-09-08
I have column ID as bigint not null, i want to alter it to bigint null i tried
ALTER TABLE aa alter COLUMN ID set data type BIGINT null ;
its giving me error
The attributes specified in the ALTER COLUMN clause for the column
"<column-name>" of the table "<table-name>" in an ALTER TABLE statement
are not compatible with the attributes of the existing column. The error
was returned for one of the following reasons.