Situation: I wanted to add a column to a table and after adding the column
i realized that i would like to change the type of the column from
varchar(n) to just char (1 character).
The column does not hold any data yet (it is empty), so changing the type
should not pose any problem.
The problem is that I don't seem to find how to do it without dumping the
table contents, recreating the table and getting the data into the table
again. There seems to be no 'ALTER TABLE DROP column' or similar.
Thanks in advance for your help.
--
# --------------------------------------------------------- #
# _ #
# Fernan Aguero | / \ #
# Bioinformatics | ASCII \ / against #
# IIB-UNSAM | ribbon / HTML #
# fernan@iib.unsam.edu.ar | campaign / \ email #
# #
# --------------------------------------------------------- #