In this blog post, let’s learn about the error message “206 The specified table is not in the database.” in Hydra and the description of the error.
Error Message
206 The specified table is not in the database.
Error Details
The keyword ROWID stands for a virtual column that exists only in simple tables. This message refers to the ROWID of a table that is actually a view that is based on a selection involving aggregate functions, grouping, or a join of two or more tables. Such query products do not have ROWID columns. Therefore this view does not have a ROWID, even though it appears to be a table. In order to use ROWID in a query, you have to apply the query to the tables that underlie the view.