Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

monetdb

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 ?

like image 641
Fopa Léon Constantin Avatar asked Apr 11 '14 08:04

Fopa Léon Constantin


1 Answers

I finally find this query

select tables.name from tables where tables.system=false ;
like image 194
Fopa Léon Constantin Avatar answered Nov 13 '22 05:11

Fopa Léon Constantin