how to change column type

Started by Fernan Agueroover 25 years ago1 messagesgeneral
Jump to latest
#1Fernan Aguero
fernan@iib.unsam.edu.ar

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 #
# #
# --------------------------------------------------------- #