changing the name of a table

todtoter
Mega Expert

I just created a table in SNOW. It is called u_layouts and it stores room layouts for all rooms on site. I want to rename the table to u_room_layout to be more proper. Is it acceptable (form a system level) to change the name of a table?

Thank you,

Tod Toter.

1 ACCEPTED SOLUTION

tschaller
Giga Contributor

As far as I know, it is not possible to change the Name of a table after it has been created. It seems to me that this is done so that any references to that table are not broken if Name is changed.



However, you may change the Label associated with that table, but not the unique name that was assigned upon creation.



So, to specifically answer your question, no it is not acceptable, let alone possible, to change the Name of a table after it has been created.


View solution in original post

2 REPLIES 2

tschaller
Giga Contributor

As far as I know, it is not possible to change the Name of a table after it has been created. It seems to me that this is done so that any references to that table are not broken if Name is changed.



However, you may change the Label associated with that table, but not the unique name that was assigned upon creation.



So, to specifically answer your question, no it is not acceptable, let alone possible, to change the Name of a table after it has been created.


todtoter
Mega Expert

ah yes, hence why the feild is read only.


Thank you,


TT