Invalid SQL Syntax: expected token: AS (Error 3728)

This error occurs when defining or creating a view or procedure through SQL DDL. The error would be generated with the following syntax: CREATE VIEW viewname SELECT…. To avoid the error, change the syntax to the following: CREATE VIEW viewname AS SELECT….

Community Additions