# Sql view in ignition

**URL:** <https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [December 4, 2023, 9:12am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652 "2023-12-04T09:12:50Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefano.sforna](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\
**Post date:** [December 4, 2023, 9:12am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/1 "2023-12-04T09:12:50Z")

</div>

Good morning,  
Is it possible create sql View in the scripts or in the Named query???

Thank you

Bye

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [December 4, 2023, 9:59am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/2 "2023-12-04T09:59:36Z")

</div>

What do you mean by "sql View"?

---

<div class="post-metadata">

**Author:** ![stefano.sforna](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\
**Post date:** [December 4, 2023, 10:05am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/3 "2023-12-04T10:05:04Z")

</div>

In my Sql server, I need to create view with Ignition

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [December 4, 2023, 10:09am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/4 "2023-12-04T10:09:23Z")

</div>

I think you are asking, "Is it possible to display data from an SQL query in an Ignition window (Vision) or Ignition view (Perspective)?" Is that correct?

The answer is "yes" to both. Which are you working with - Vision or Perspective?

---

<div class="post-metadata">

**Author:** ![stefano.sforna](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\
**Post date:** [December 4, 2023, 10:14am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/5 "2023-12-04T10:14:37Z")

</div>

No, It isn't not correct.  
In Sql Server management studio, I can create View in the Sql Server.  
I ask if it's possible to create Sql Server View also with Ignition.

---

<div class="post-metadata">

**Author:** ![Learner\_Ignition](https://avatars.discourse-cdn.com/v4/letter/l/b3f665/32.png) [@Learner\_Ignition](https://forum.inductiveautomation.com/u/Learner_Ignition)\
**Post date:** [December 4, 2023, 10:52am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/6 "2023-12-04T10:52:50Z")

</div>

Yes can create view using Named Queries with Query Type as **Update Query**

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [December 4, 2023, 10:55am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/7 "2023-12-04T10:55:19Z")

</div>

if You want SQL CREATE VIEW Statement, use this syntaxe:

```auto
CREATE VIEW identifiantTest
	SELECT id_center
	FROM turbine
	WHERE id_center >200

```

Query type \*\* **Update Query** \*\*

I test it , it work.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [December 4, 2023, 11:09am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/8 "2023-12-04T11:09:49Z")

</div>

> [@sebastien\_ng](#):
>
> Query type **Update Qlect uery**

There is no way that would work. Please take care in your writing.

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [December 4, 2023, 11:17am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/9 "2023-12-04T11:17:29Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/7/67dd7ca57e3347ec966a12e58e584f6152325f43.png)  
is not something like that he is waiting?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 4, 2023, 11:22am UTC](https://forum.inductiveautomation.com/t/sql-view-in-ignition/82652/10 "2023-12-04T11:22:55Z")

</div>

He's talking about the spelling. 😉