Title: edit view only table query
Last modified: September 25, 2023

---

# edit view only table query

 *  Resolved [rianyingg](https://wordpress.org/support/users/rianyingg/)
 * (@rianyingg)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/edit-view-only-table-query/)
 * As the title says..
   My company’s wordpress was built before I’m even an employee
   and I am needed to edit a table’s SQL query from the Data Explorer (i have provided
   the link to the screenshot). Apparently it is view only and I don’t know how 
   to edit it. Please help
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fedit-view-only-table-query%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/edit-view-only-table-query/#post-17075826)
 * Hi [@rianyingg](https://wordpress.org/support/users/rianyingg/),
 * You can edit a View by executing an ALTER VIEW statement using the [Query Builder](https://wpdataaccess.com/docs/query-builder/query-builder-getting-started/).
 * Hope that helps! Let us know if you have more questions.
 *  Thread Starter [rianyingg](https://wordpress.org/support/users/rianyingg/)
 * (@rianyingg)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/edit-view-only-table-query/#post-17075845)
 * Hi [@kimmyx](https://wordpress.org/support/users/kimmyx/),
 * Thanks for the quick response!
   I have made the necessary changes thanks to your
   help.
 * Have a good days ahead!
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/edit-view-only-table-query/#post-17075864)
 * Hi [@rianyingg](https://wordpress.org/support/users/rianyingg/),
 * You’re welcome! Glad I could help. ☺
 * Feel free to create a new thread if you have more questions about the plugin.
 * Have a great day as well!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘edit view only table query’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [2 years, 8 months ago](https://wordpress.org/support/topic/edit-view-only-table-query/#post-17075864)
 * Status: resolved