# Could not create or replace the sql view in ignition

**URL:** <https://forum.inductiveautomation.com/t/could-not-create-or-replace-the-sql-view-in-ignition/38620>\
**Category:** Ignition\
**Created:** [September 12, 2020, 6:27am UTC](https://forum.inductiveautomation.com/t/could-not-create-or-replace-the-sql-view-in-ignition/38620 "2020-09-12T06:27:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Premnath.K](https://avatars.discourse-cdn.com/v4/letter/p/b487fb/32.png) [@Premnath.K](https://forum.inductiveautomation.com/u/Premnath.K)\
**Post date:** [September 12, 2020, 6:27am UTC](https://forum.inductiveautomation.com/t/could-not-create-or-replace-the-sql-view-in-ignition/38620/1 "2020-09-12T06:27:15Z")

</div>

Hello Team,

I need to run create/replace/drop SQL views from the ignition I tried in the transaction group, named query & report data source SQL query but could not do I am getting the following error

org.postgresql.util.PSQLException: ERROR: cannot drop columns from view

But when I execute the same query in pg admin(postgres) its working normal