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.
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.