If MonetDB says the table does not exist, then it most probably indeed does not exist, and hence you cannot remove it (well, there is then obviously not need to remove the non-existing table). You can double-check with, e.g., select * from "DM_MON_TSV_STG_T1"."AMA_US_IRI_8135_2001"; select * from schemas s join tables t on s.id = t.schema_id where s.name = 'DM_MON_TSV_STG_T1' and t.name = 'AMA_US_IRI_8135_2001'; I would be surprised (and consider it a bug that should be reported and fixed), if MonetDB excepted the given create statement without issuing an error; cf., sql>create table t (); syntax error, unexpected ')', expecting FOREIGN or PRIMARY or UNIQUE in: "create table t ()" Best, Stefan ----- On Mar 10, 2018, at 8:29 AM, Sreejith Sharma Sreejith.Sharma@harman.com wrote:
All,
We are finding a strange issue where below table has been created via a shell script. Strangely it doesn’t show up any columns and when we try to drop it’s saying table doesn’t exists.
Is there any way below can happen? Is this because it’s corrupted? How can we remove this?
CREATE TABLE "DM_MON_TSV_STG_T1"."AMA_US_IRI_8135_2001" (
);
Regards,
Sreejith
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |