RE: [SQL] Change type of column

2000-07-11 Thread Rob S.
To: [EMAIL PROTECTED] > Subject: [SQL] Change type of column > > > Hello, > > how can I change the type of a column, e.g. from varchar() to text? > Or is it possible to drop (i.e. delete) a column without > creating a new table from the old one but without that column, > droppin

[SQL] Change type of column

2000-07-11 Thread Volker Paul
Hello, how can I change the type of a column, e.g. from varchar() to text? Or is it possible to drop (i.e. delete) a column without creating a new table from the old one but without that column, dropping the old table and renaming the old to the new? Thanks, Volker Paul