Hello i want to add another bit column to my table.

Columns were

userID ---- userName

Now i want to add a column

userID ---- userName ---- isSuperUser


Now i have values in my table.

I want to add the column isSuperUser to my table and set old row's isSuperUser column to 1 ...


How can I achieve this?


Do i need to drop the table and create it again?

Sybase documentation for ALTER TABLE:
SyBooks Online

datatype
is any system datatype except bit or any user-defined datatype except those based on bit.

hello ,

you can using this command

1> alter table table name add isSuperUser datatype
2> go

then use this command

1> update table name
2> set isSuperUser=1
3> go



good luck