[Solved] Why this sql statement doesn’t working —-“ALTER TABLE ALTER COLUMN email varchar(100) not null;”—-?

by


Hi you can try like this 

ALTER TABLE table_name  ADD  email varchar(100) not null

you can change column name

ALTER TABLE tableName RENAME COLUMN "oldcolname" TO "newcolname" datatype(length);

you can modify also 

ALTER TABLE table_name
MODIFY COLUMN column_name datatype;

solved Why this sql statement doesn’t working —-“ALTER TABLE ALTER COLUMN email varchar(100) not null;”—-?