ALTER TABLE OPD 
DROP COLUMN OPD_PAT_CITY, 
DROP COLUMN OPD_PAT_ADDR, 
DROP COLUMN OPD_PAT_NEXT_KIN, 
DROP COLUMN OPD_PAT_SNAME, 
DROP COLUMN OPD_PAT_FNAME, 
DROP COLUMN OPD_PAT_FULLNAME;