The following example changes the attributes of the dept_no column in the department table to include a TITLE phrase:
ALTER TABLE personnel.department ADD dept_no TITLE 'Depart';
ALTER TABLE personnel.department ADD dept_no TITLE 'Depart';