Previous Topic: -87 - CANNOT USE <UNION> AND <UNION ALL> IN SAME STATEMENTNext Topic: -103 - MUST USE COLUMN FUNCTIONS IF HAVING CLAUSE WITH NO GROUP BY

SQL Codes › SQL Return Codes -1 through -999 › -101 - A SYNONYM ON A SYNONYM IS NOT ALLOWED

-101 - A SYNONYM ON A SYNONYM IS NOT ALLOWED

Reason:

You attempted to create a synonym on a synonym. This is not allowed. Synonyms can be created for tables or views only.

The SQLSTATE that equates to this SQL return code is 0AS03.

Action:

Create the synonym on the table or view.