How to change data type of columns without dropping it <pre><code>CREATE TABLE DEPARTMENT( DEPARTMENT_NAME VARCHAR(25) NOT NULL PRIMARY KEY , BUDGET_CODE INT NOT NULL, OFFICE_NUM INT NOT NULL, PHONE NUMERIC NOT NULL , ); </code></pre> <p>I have this table that I am creating but i want to change budget code and office number in varchar instead of int. Is there a way to do this. this table is linked to other tables with foreign key. So i can't drop it and create a new one.</p>