how to change the scoope of a table

[ibilge]

Hi all,

i want to change the Scope of a Table, which is now in global. But i don't want to cause any mistake. That's why i wanted to get your opinion beforehand.

I will change the Scope of cmdb_ci Table , but i have to be careful since it is very frequently used table.

Can you please help me with what to pay attention to and what steps to follow?

Thanks in advance!

[SN_Learn]

Hi @ibilge ,

You cannot change the scope once the table is created. You need to recreate the table along with the field if you want it in a custom scope from scratch.

If you want to make any database changes then create an update set and work on it. You can back it out if you don't want those changes and also move the update set from one instance to another to move the changes across the instances.

Mark this as Helpful / Accept the Solution if this helps

[SN_Learn]

Mark this as Helpful / Accept the Solution if this helps

[Community Alums]

Hi @ibilge ,

Unfortunately there no way you can change the scope of already created table, you have to create new table from scratch and add all the fields.

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak

[ibilge]

Hi @Community Alums  and @SN_Learn ,

Thanks a lot!

Ok. And what should I pay attention to when creating this table from scratch and using it instead of the global scope table? To avoid encountering any errors?

[Community Alums]

Hi @ibilge ,

You can create table in custom scope and add specific fields . Please pay attention on scope table name, fields and field type.

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak