Can I add a record to sys_dictionary by using a script?

[erantal2000]

Hi everyone,

I am trying to create a script that will automatically add field to a table.

Is there a way I can do this? maybe by adding a record to sys_dictionary?

I tried to do that by using GlideRecord but it didn't work.

Any ideas?

[SanjivMeher]

Can you share your script?

[erantal2000]

var r = new GlideRecord('sys_dictionary');
r.initialize();
r.active = 'true';
r.internal_type = 'string';
r.name = 'my_table_name';
r.column_label = 'Field 1';
r.element = 'field1';
r.max_length = 40;
r.table_reference = 'false';
r.insert();

Not working 😞

[SanjivMeher]

I used below script. it worked fine. I also added the sys_scope field and commented the active=true

var r = new GlideRecord('sys_dictionary');
r.initialize();
//r.active = 'true';
r.internal_type = 'string';
r.name = 'incident';
r.column_label = 'Field 1';
r.element = 'field1';
r.max_length = 40;
r.table_reference = 'false';
r.sys_scope='global';
r.insert();

[erantal2000]

Sorry, not working 😞

I need it in a specific scope so I tried to use the following line:

r.sys_scope = 'SYS_ID_OF_SCOPE';

And when it didn't work I tried your line referring to the global scope.

Both didn't work 😞

I read somewhere that there is a utility called GlideTableCreator, but I can't find any reference about it, so I can't try it. Maybe someone knows anything about it?