cancel
Showing results for 
Search instead for 
Did you mean: 

What DDL works for ALTER VIEW or CREATE VIEW in BODS SQL transformation for MSSQL 2016

Former Member
0 Kudos

DROP VIEW and both DDL/DML statements for TABLES, CONSTRAINTS and INDEX we have no problems executing.
But ALTER VIEW and CREATE VIEW DDLs fail.
Errors we get are "CREATE VIEW' must be the first statement in a query batch" or Incorrect syntax near the keyword 'SELECT' (the "select 1 ab" statement at the end that is required) or Prepared statement is not a cursor-specification.

Accepted Solutions (0)

Answers (0)