-- SQLServer alter varchar(4000) to TEXT -- mrequest ALTER TABLE mrequest ALTER COLUMN reason TEXT; ALTER TABLE mrequest ALTER COLUMN plandesc TEXT; ALTER TABLE mrequest ALTER COLUMN remark_wf TEXT; ALTER TABLE mrequest ALTER COLUMN responsibility TEXT; ALTER TABLE mrequest ALTER COLUMN destination TEXT; ALTER TABLE mrequest ALTER COLUMN conclusion TEXT; ALTER TABLE mrequest ALTER COLUMN language TEXT; ALTER TABLE mrequest ALTER COLUMN behavior TEXT; ALTER TABLE mrequest ALTER COLUMN position_specific TEXT; ALTER TABLE mrequest ALTER COLUMN orther_knowledge TEXT; ALTER TABLE mrequest ALTER COLUMN examdata TEXT; ALTER TABLE mrequest ALTER COLUMN pregnantdesc TEXT; ALTER TABLE mrequest ALTER COLUMN qualification TEXT; ALTER TABLE mrequest ALTER COLUMN software TEXT; ALTER TABLE mrequest ALTER COLUMN remark_hr TEXT; ALTER TABLE mrequest ALTER COLUMN other TEXT; ALTER TABLE mrequest ALTER COLUMN experience TEXT; ALTER TABLE mrequest ALTER COLUMN impairdesc TEXT; ALTER TABLE mrequest ALTER COLUMN cancel_reason TEXT; ALTER TABLE mrequest ALTER COLUMN router TEXT; -- mapplicant ALTER TABLE mapplicant ALTER COLUMN jobexp TEXT; ALTER TABLE mapplicant ALTER COLUMN education TEXT; ALTER TABLE mapplicant ALTER COLUMN contact TEXT; ALTER TABLE mapplicant ALTER COLUMN personal TEXT; ALTER TABLE mapplicant ALTER COLUMN skill TEXT; ALTER TABLE mapplicant ALTER COLUMN jobrouter TEXT; ALTER TABLE mapplicant ALTER COLUMN family TEXT; -- mappointment ALTER TABLE mappointment ALTER COLUMN detail TEXT; -- mjobrouter ALTER TABLE mjobrouter ALTER COLUMN jobrouter TEXT; -- mexam ALTER TABLE mexam ALTER COLUMN examdata TEXT; ALTER TABLE mexam ALTER COLUMN question TEXT; -- crecruit ALTER TABLE crecruit ALTER COLUMN object TEXT;