Tag: alter table column not null to nullable


alter table column not null to nullable

For oracle :

ALTER TABLE “TABLENAME” MODIFY (“COLUMNNAME” NULL);

For SQL Server:

ALTER TABLE “TABLENAME” ALTER COLUMN “COLUMNNAME” varchar(255) NULL

for sql server must have column type.