How do I find all the tables in a database?

[lawrence k]

I am struggling and failing to get all the data out of a FileMaker database. I know MySql, but I do not know FileMaker. In MySql, if I wanted to find every table in a database, I would simply log into the command line and type "Show Tables". Then I would get a list of every table in the database.

Is there a way to do something similar in FileMaker.

I'm offering $20 prize to anyone who can help me figure this out.

I posted more details here:

http://www.filemakeremergency.com/question/show/id/4

(That website is, of course, modeled after our WordPress site: http://www.wpquestions.com/

Edited December 1, 2010 by Guest

[comment]

Is there a way to do something similar in FileMaker.

Not really (at least I don't know of one).

a lot of the tables seem to be Joins and self-joins. I do not need these, only the "real" underlying tables. How do I find them?

Click the Tables tab in Manage Database window.

I can try to go in and walk through every file and try to manually export each table, but that seems error prone, to me.

You could try something like:

1. Make a copy of the file;

2. Delete all layouts in the copy;

3. Create a new layout for each table (i.e. each "base" table listed under the Tables tab);

4. Write a script to loop among the layouts, show all records and export.

Edited December 1, 2010 by Guest

[bruceR]

You open the database.

Go to File: Manage Database

Choose the tables tab.

There they are.

Edited December 1, 2010 by Guest