How to get a list of tables in a monetdb database?

Question

In postgresql, you can have all table 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 a list of tables?

Answer 1

I finally found this query

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

Answer 2

If you use mclient, on the command line, you can simply use the "\ d" command to display all the tables in the current database.

sql> \d

TABLE  sys.table1 

TABLE  sys.table2

TABLE  sys.table3

Also, use the "\ d tablename" command to view the table metadata, which is equivalent to "show create table" in mysql.