changing the type of the field in the table from int to int64

(0) Share

Report

Posted on by dark_knight

1,269

Hello,

I have a table with the field that stores int values. Now I need to insert int64 values to that field. Table field is based on EDT which is inherited from int. How to change the table field in order to save int values that I already have? If I create new int64 EDT and will point out this new EDT in the properties of my table field will it work then? Won't I lose my int values already stored in this field?

Thanks.

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!

Hi Azat,

You can create new int64 field, copy data from the old field to the new field via job or SQL script, and use the new field in code instead of the old one.

Was this reply helpful? Yes No
Verified answer

Leo Chen Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

You are not allowed to change a field's EDT from int to int64 types, as they are different types. It's just like you cannot change a field type from string to Real.

Was this reply helpful? Yes No
dark_knight 1,269 on at

Like (0)

Report
Copy link

Link copied!

Thank you. Will proceed with this))

Was this reply helpful? Yes No