Database with thousands of tables

Ok, what’s the best approach here? Don’t want to wait for the load of all the table names… Too time consuming and SC becomes very slow. Is it possible to disable this and type the tablenames by hand?

Re: Database with thousands of tables

thousands of table…i hope sc can create dinamicaly macro for read thousand of table such as sc_table(‘table_variable’)…where table_variable can change dinamically.

Re: Database with thousands of tables

Problem is that when you need to work with a database of that size the dynamic lookup of tables works too slow. A manual approach (to allow the table entered manually) would be best here.

Re: Database with thousands of tables

Hello,

Depending on the RDBMS you are working with, you could create a new User and set permission only to a few tables.

regards,
Bernhard Bernsmann

Re: Database with thousands of tables

We’'re working with oracle in our pilot. I’ll discuss this with the devs. I still think there should be a more smooth solution for this…