USE billing; ALTER TABLE contacts CHANGE COLUMN postcode postcode VARCHAR(16) DEFAULT NULL;