Hello All,
I've to alter a column of a table. Here is the column definition

create table foo(
...
foo1 VARCHAR(255) Not Null Default 'ABC'
)

I want to alter the column by removing the default value. I tried with the syntax

alter table hrod_rpca alter hrod_sp_id type VARCHAR(255) Not Null;

But it gives me a token unknown error for 'Not'.
Can someone help me out for the syntax?
Thanx in advance.
Mahesh.


---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger

[Non-text portions of this message have been removed]