Could not create or replace the sql view in ignition

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