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

by

[ad_1]

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;

[ad_2]

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