Edit data type for an existing custom property

Question

Good day everyone,

Simple question, as in the title, is it possible to edit the data type of a custom property (i.e. previously created as varchar, to be made as int.) via SQL ?

I mean, I know that SQL will allow me to do that, but I don't know if Orion will like it.

Same question applies also to the name of the column.. is it possible to change it?

Thanks.

LadaVarga · Accepted Answer

Hello,

You cannot change custom property name or type.

Possible workaround is use import/export custom property.

1. Export that custom property.

2. Create new custom property.

3. Import csv to the new Custom property

4. DElete source custom property if you need.

Lada

Edit data type for an existing custom property

Top Replies