# Changing Table Name Globally

**URL:** <https://www.five.org/t/changing-table-name-globally/643>\
**Category:** How do I?\
**Created:** [May 10, 2026, 5:08pm UTC](https://www.five.org/t/changing-table-name-globally/643 "2026-05-10T17:08:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RMittelman](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/rmittelman/32/447_2.png) [@RMittelman](https://www.five.org/u/RMittelman)\
**Post date:** [May 10, 2026, 5:08pm UTC](https://www.five.org/t/changing-table-name-globally/643/1 "2026-05-10T17:08:21Z")

</div>

I have a requirement to change a table name from **StudyGroups** to **Groups**. While this seems simple at first look, there are a LOT of things to change, such as function code, libraries, queries, etc.

I also have to change not only the basic tables, but join tables also.

Is there a way to search all function code globally, or must I load each function and edit and save, then repeat for libraries and queries?

Thanks…

---

<div class="post-metadata">

**Author:** ![eltonsantos](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eltonsantos](https://www.five.org/u/eltonsantos)\
**Post date:** [May 11, 2026, 4:53am UTC](https://www.five.org/t/changing-table-name-globally/643/2 "2026-05-11T04:53:28Z")

</div>

Hi Ron,

You can use the menu ‘ **Code Search** ’, under the parent menu ‘ **Tools** ’, there you are able to search for all the functions/codes that use the word ‘StudyGroups’.

Please, use the image below as a reference.

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/five/original/2X/5/5260c4a7d2964695125a21c34dfe4b8445b7db6f.png)

Regards,

Elton S

---

<div class="post-metadata">

**Author:** ![RMittelman](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/rmittelman/32/447_2.png) [@RMittelman](https://www.five.org/u/RMittelman)\
**Post date:** [May 11, 2026, 10:17pm UTC](https://www.five.org/t/changing-table-name-globally/643/3 "2026-05-11T22:17:52Z")

</div>

Thanks Elton! This is great. Didn’t realize this was available.

It only shows functions and queries, but that is the biggest area to go through. Libraries are not included (unless they are and none of them contain the search term). But even if not, I have a very small number of libraries to go through.

**Form Code** and **Process Code** don’t seem to work, they show an error about OnComplete not being there.

But I _think_ I can simply modify table name from StudyGroups to Groups, then also change StudyGroupKey to GroupKey in the join tables, then go through all of the functions and queries using the code search, then finally go through the libraries to find any old references to StudyGroup or StudyGroupKey and change them. Then finally, verify everything works, especially validating all field names in the DataViews.

Can you think of anything I missed in these steps?

Thanks SO much!

**PS. It doesn’t seem to allow me to change the table name from StudyGroups to Groups. It says something about a reserved word. More specifically, the table name can be changed but the Data Source ID cannot. Can you advise on this?**

---

<div class="post-metadata">

**Author:** ![eltonsantos](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eltonsantos](https://www.five.org/u/eltonsantos)\
**Post date:** [May 12, 2026, 2:11am UTC](https://www.five.org/t/changing-table-name-globally/643/4 "2026-05-12T02:11:16Z")

</div>

Hi Ron,

Thank you for the question.

We do not allow any MySQL reserved words to be used as a Data Source (table name), because MySQL will generate an error for it.

This is part of MySQL’s restrictions.

Regards,

Elton S

---

<div class="post-metadata">

**Author:** ![RMittelman](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/rmittelman/32/447_2.png) [@RMittelman](https://www.five.org/u/RMittelman)\
**Post date:** [May 12, 2026, 4:23am UTC](https://www.five.org/t/changing-table-name-globally/643/5 "2026-05-12T04:23:30Z")

</div>

Thanks Elton.  
Are you saying that “Groups” is a MySQL reserved word? I imagine “Group” is (as in Group By), but I thought “Groups” would work. Strangely it allowed me to change the table name to “Groups”, but wouldn’t let me change the data source name. Why would MySQL let me change the table name if it was a reserved word? It seems more like Five itself won’t let me change the data source name to “Groups”

Is that also true if I tried to create a brand new table and data source called “Groups”?