# Way to get SQL highlighting like SQL Query Browser?

**URL:** <https://forum.inductiveautomation.com/t/way-to-get-sql-highlighting-like-sql-query-browser/80592>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [October 17, 2023, 12:18pm UTC](https://forum.inductiveautomation.com/t/way-to-get-sql-highlighting-like-sql-query-browser/80592 "2023-10-17T12:18:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [October 17, 2023, 12:18pm UTC](https://forum.inductiveautomation.com/t/way-to-get-sql-highlighting-like-sql-query-browser/80592/1 "2023-10-17T12:18:19Z")

</div>

Using 8.1.25.

I am making a project to manage an un-normalized database which is never going to be normalized due to multiple downstream services relying on the current shape of it, one schema per plant.

My project is a SQL generator, one example is if I want to add a column to a table, I have to do an `ALTER TABLE {schema}.SomeTable ADD someColum INT;` and then I iterate through all 50ish schemas and create a SQL script I can run in SSMS, one ALTER statement per schema.

This works fine, but in my vision project what would be just a nice little extra, would be if in my text areas I got the same highlighting that happens in the named queries or the SQL Query Browser where keywords where highlighted blue. Is this possible and how?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [October 17, 2023, 12:47pm UTC](https://forum.inductiveautomation.com/t/way-to-get-sql-highlighting-like-sql-query-browser/80592/2 "2023-10-17T12:47:01Z")

</div>

No, we (or you) would need to add some kind of code editor Vision component.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [October 17, 2023, 12:47pm UTC](https://forum.inductiveautomation.com/t/way-to-get-sql-highlighting-like-sql-query-browser/80592/3 "2023-10-17T12:47:45Z")

</div>

Ok fair enough, not worth that much trouble.