Multiple columns in single ALTER TABLE statement?

[Randall Parker]

Can one modify multiple columns in a single ALTER TABLE statement?
It doesn't look like it from the syntax diagram.

Also, can one set a column to NOT NULL and to DEFAULT AUTOINCREMENT
in a single ALTER TABLE statement? Again it doesn't look like it.

[Paul Horan[TeamSybase]]

Yes, of course you can. Just separate the individual columns being altered
with commas.

Alter table MyTable
MODIFY Column1 default 1,
DROP Column15,
ADD Column79 varchar(20)
;

There are things you can't logically do, like add a column with a NOT NULL
constraint to a table with existing data - that has to be done in three
separate steps.

Paul Horan [TeamSybase]
Buffalo, NY

"Randall Parker" <rgpa...@west.net> wrote in message
news:MPG.15f9b28a1...@forums.sybase.com...