Previous Topic: -109 - VIEW COLUMN CONTAINING EXPRESSION OR FUNCTION USED ILLEGALLYNext Topic: -111 - THE VIEW IS NOT UPDATABLE BECAUSE IT CONTAINS A SUBQUERY

SQL Codes › SQL Return Codes -1 through -999 › -110 - ORDER BY IS NOT ALLOWED IN A VIEW DEFINITION

-110 - ORDER BY IS NOT ALLOWED IN A VIEW DEFINITION

Reason:

The user had an ORDER BY clause in a CREATE VIEW statement. This is not valid.

The SQLSTATE that equates to this SQL return code is 42601.

Action:

Remove the ORDER BY clause.