Get all documents of the database

[AFatNiBBa]

Is there a way to get all the documents of the database regardless of the table?
For example in neo4j you can do something like:

MATCH (n) RETURN n

[tobiemh]

Hi @AFatNiBBa , so the way SurrealDB works is slightly different. In SurrealDB everything belongs to a table, while in Neo4j, everything is described with metadata instead.

So in SurrealDB there is not (yet) a way of getting all items, but you can select from multiple different tables at the same time. So technically you can select every table type, which would have the same effect. But obviously not quite as nice...

SELECT * FROM person, user, admin, game, movie, actor;

[alkeryn]

sorry for the necrobump but is there a way to get a list of all tables ?

[RayZwankhuizen]

Isn't that with INFO FOR NS; ?

[tobiemh]

@alkeryn to get all of the defined tables you can use:

INFO FOR DB;

[alkeryn]

thanks ! :)