1 -- @tag: column_type_text_instead_of_varchar2
2 -- @description: Spaltentyp auf Text anstelle von varchar() für diverse Spalten Teil 2
3 -- @depends: column_type_text_instead_of_varchar
7 ALTER COLUMN shiptocity TYPE TEXT
8 , ALTER COLUMN shiptocontact TYPE TEXT
9 , ALTER COLUMN shiptocountry TYPE TEXT
10 , ALTER COLUMN shiptodepartment_1 TYPE TEXT
11 , ALTER COLUMN shiptodepartment_2 TYPE TEXT
12 , ALTER COLUMN shiptofax TYPE TEXT
13 , ALTER COLUMN shiptoname TYPE TEXT
14 , ALTER COLUMN shiptophone TYPE TEXT
15 , ALTER COLUMN shiptostreet TYPE TEXT
16 , ALTER COLUMN shiptozipcode TYPE TEXT