Home / Q&A / remove all _0 from field names on new base view
You can translate the question and the replies:

remove all _0 from field names on new base view

we have config turned on where if a field is renamed because of space or special characters it appends underscore 0 to the end of the field name, we want to keep that feature on but I have a view of like 100 fields and half of them have it. Is there an easy way using the VQL shell to replace all of the underscore 0 references at once?
Rename Base view Vql shell
user
07-10-2021 14:23:59 -0400

1 Answer

Hi, With this scenario, I often use the **ALTER TABLE** command from the VQL shell. More details are found in the *alter column* clause in the [Modifying a Base View](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/creating_a_base_view/modifying_a_base_view/modifying_a_base_view) guide. Hope this helps!
Denodo Team
17-10-2021 22:51:00 -0400
You must sign in to add an answer. If you do not have an account, you can register here