I'm having a similar issue to Unable to view tables in Database Expert | SAP Community. My database has almost 20,000 tables. But, I'm not able to see them all. I found the above answer, but I am not able to find that setting in the Windows Registry. I am on Windows 10 Pro.
Crystal Reports uses system resources so it's limited in how many Tables it can display, even after altering the Registry.
Go into the Database Expert, right click on your DB connection and select Options:
You can then add filtering under the Data Explorer section, uncheck all except Tables, that can free up a lot of DB info being loaded into memory.
If that still doesn't show all then start adding filter for the Owner or Tables.
Usually MS SQL Server has no issue but DB's like Oracle does have problem due to the usual amount of database available.
The registry path has changed since 2009. It's also different if you're using Crystal 2020, which is 64-bit. See 2165260 - *** Master KBA *** List of Registry Keys used in Crystal Reports, Crystal Reports for Visu... for information about the correct path and setting to use.
If you can't get to the KBA, let me know and I'll post the information here.