Dear Heinz, No, the easiest way to drop these tables would be to add some code that would invoke the InnoDB internal SQL parser, which has lots of quirks and is very happy to crash on the tiniest error. For creating some system tables, there is some code in storage/innobase/dict/dict0crea.cc, and the grammar is defined in storage/innobase/pars/pars0grm.y. I realize that there is no DROP keyword, only CREATE. These tables could be dropped by DELETE FROM the 4 tables SYS_TABLES, SYS_COLUMNS, SYS_INDEXES, SYS_FIELDS. (There are no FOREIGN KEY constraints or virtual columns on them, therefore SYS_FOREIGN, SYS_FOREIGN_COLS, SYS_VIRTUAL do not matter.)
Marko On Thu, Aug 21, 2025 at 1:06 PM heinz--- via discuss <[email protected]> wrote: > > dear marko, > > thanks for the explanation! > > i assume there's no easy (undocumented) possibility to drop these tables "by > hand" on my server?? > > ciao > H. > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] -- Marko Mäkelä, Lead Developer InnoDB MariaDB plc _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
