Getting Table Names

[Tom Kennedy]

TableNames ( FileName ) will get all of the Table Occurrences. Is there a function or method to get the Table Names?

[Fenton]

I don't think so; at least nothing comes to mind, and I've also tried to find something. It is similar to having a folder full of alias files (shortcuts on PC). If you listed that folder, you'd get the list of what's in it, not the names of the original files.

Database Design Report would have the "base tables," though not entirely convenient. FileMaker uses the table occurrences in all operations, not the base tables. AppleScript also only sees the table occurrences.

I don't know about Java or SQL, whether they have a command to see only the base tables.

I agree that it would be useful to have such a function. For example: you need to create an series of "restore" imports, one for each base table. You have a lot of tables. It would be convenient to be able to see them, rather than working off a screenshot of the tables.

[Tom Kennedy]

Thank you so much for your research.

Your example (restore imports) is what I am trying to do and is exactly why I would like to know how to do this. I have 115 tables and 477 TOs and was trying to make sure that I had not missed any tables in doing the restore import.

Thanks again for your input.