2173448 - Error 3701 when trying to drop an object - SAP ASE

• Error 3701 is returned when dropping an object
• Example of two common scenarios:

1. Using no fully qualified name, so without the owner prefix
   
   drop table table1
   go
   
   Msg 3701, Level 11, State 1:
   Server 'ASE', Line 1:
   Cannot drop the table 'table1', because it doesn't exist in the system catalogs.
   
   
2. Using the fully qualified name including owner prefix (database.login.object_name) when object was created with alias
   
   drop table db2.login1.table2 
   go
   
   Msg 3701, Level 11, State 1:
   Server 'ASE', Line 1:
   Cannot drop the table 'db2.login1.table2', because it doesn't exist in the system catalogs.

SAP Adaptive Server Enterprise (ASE) all versions

drop table, procedure, view, trigger, constraint, default, 3701 , SQLCODE=3701 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error