Subject Alter Table syntax
Author Mahesh Ishwar
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.

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

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