Re: How to add columns with datatype No Null to existing table with data?

> I tried with 'alter table table_name add (column_name datatype no null)' but > it's not accepted. First, you have a syntax error...you need "not null". Add the column WITHOUT the "not null" clause first. Populate that column in all rows. Add the "not null" constraint.