Change from String to Long number in database

[kanishka271]

Hello,
I am trying to change the column type to long number in a database. I used DB SQL Executor node and typed the following statement;

ALTER TABLE “TableName” ALTER COLUMN “Column Name” Long

However, it is giving me the following error,

Execute failed: Column, parameter, or variable #25: Cannot find data type Long.

how do I fix this?

If there is an alternative way to do this task let me know

Thanks in advance

[ArjenEX]

@kanishka271 Answering this question without knowing what db type you’re working with is challenging

There are some examples out there, like:

PostgreSQL Change Column Type: Step-by-Step Examples

Most likely it’s TYPE LONG that you need to use.

[bruno29a]

Hi @kanishka271 , as per @ArjenEX , it is quite difficult to answer your question without know what db system you are on.

Most likely, the type “Long” is not supported. Maybe try bigint instead?