Cacher is the code snippet organizer for pro developers

--Add column

ALTER TABLE APP.EMPLOYEE ADD NEW_COL VARCHAR(25)			
			
ALTER TABLE APP.EMPLOYEE ADD NEW_COL CHAR(25) DEFAULT '2' NOT NULL

ALTER TABLE SCHEMA.TABLE ALTER "COLUMN-NAME" SET DATA TYPE VARCHAR(255);