ALTER TABLE ACCOUNT ADD COLUMN FULL_NAME VARCHAR(100); UPDATE ACCOUNT SET FULL_NAME = USER_NAME WHERE FULL_NAME IS NULL; ALTER TABLE ACCOUNT ALTER COLUMN FULL_NAME SET NOT NULL;