How can I get a list of all available tables in my own authenticated CartoDB account with a SQL statement?

This returns null:

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

Alternatively, could it be done with CartoDB.js?

1 Answer 1


You cannot do it from unauthenticated queries. You can do it inside the dashboard though with this,

SELECT * FROM CDB_UserTables()

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.