Just to know a small information
first i had a table and i had added a new column to that table now as below
alter table [tablename] add columnname INTEGER Not NULL DEFAULT 0
now i need to modify the above mentioned column to NOT NULL alone now it should not have the default value
so can this be done
if done could tell me the query for this
funny - seems to be difficult the get ride of the default value
never the less
alter table [tablename] add columnname DEFAULT NULL;
might solve the issue.
As the column is defined as not null a missing value for B will cause a "Column 'b' is NOT NULL. Give the column a value."