sybase add column

Begin

ALTER TABLE Order_def ADD shared char(3) DEFAULT 'N' NOT NULL CONSTRAINT CHK_shared CHECK (shared IN ("Yes","No","-") )
End
GO