Re: [SQL] Change of data type

[Shoaib Mir]

You can do the following:

ALTER TABLE table-name ALTER colum-name TYPE text;


Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 8/8/06, Kumar Dev <[EMAIL PROTECTED]> wrote:

Use Alter table notebook from control center

right click on the table and open alter table notebook

you can drop a column or add a column or change the datatype

 

Kumar

 

On 8/7/06, Judith <[EMAIL PROTECTED] > wrote:

   Hello everybody, excuse me how can I change de data type of a field,
I currently have:

   material character(30)

   but I now want the field in text type like this:

   material  text

   somebody knows if ALTER TABLE has some option to do this?, or How
can I do that?


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

--
Kumar
DB2 DBA & SAP Basis professional