Search code examples
monetdb

How to have the list of table in a monetdb database?


In postgresql, one can have all tables names by running the following query

SELECT table_name FROM information_schema.tables WHERE table_schema='public';

Is there something similar in monetdb to have the list of tables ?


Solution

  • I finally find this query

    select tables.name from tables where tables.system=false ;