Is there a way to move all tables to system, then only move a few back

Question

I am trying to make a quick front end for a system that has over 100 tables in the DB. They only need to see 4 of these. Is there a way to move all tables to System and I can then move the 4 back. It is very slow to drag that many tables to System.

thanks

Answer 1

There are two different ways to resolve this issue:

1. Create a database-user for that application (Strongly Recommended), See: Database User
2. Set the Database Defaults so that new tables show up as System.

Comments

This was a big help.  Thank you.