Search code examples
teradata

Is there any way to change datatype in teradata?

I want to change the INTEGEr field in my table to VARCHAR. How can I do this?

Do I have to create a new table?

Solution

  • Yes, you have to create a new table, there's no way to change the datatype from numeric to VarChar.

    Simply create a new table and Insert/Select the existing data using CAST(existingCol AS VARCHAR(xx))