add constrain in exsiting table

karthickkuchanur

Please help me how rename my column and add contrain to my table

I have tried alter but i cant able to add constrain

debasisdas

To rename a column in an existing table, the ALTER TABLE syntax is:

Expand|Select|Wrap|Line Numbers

     ALTER TABLE table_name

     RENAME COLUMN old_name to new_name;

note ---it supports Oracle 9i Release 2 onwards

to add a constraint try the following sample syntax

Expand|Select|Wrap|Line Numbers

 ALTER TABLE order_status2

ADD CONSTRAINT order_status2_id_ck CHECK (id > 0);

re: add constrain in exsiting table