Announcement

Collapse
No announcement yet.

Grouping tables

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grouping tables

    I am using an ERP system where companies are created by appending the company name to the beginning of the table name.
    As a result I have hundreds of tables in my database but am only interested in those belonging to a particular company.
    I was looking at a group but there is no easy way that I can see to move the many tables to the group. It looks like I can only go one by one.
    Is there an easier way to create a group or should I be doing something else?

    Thanks

  • #2
    1. Open your database.
    2. Right-click the Tables note on the connection tree and select New Group.
    3. Give a name to the group.
    4. Multi-select the tables you want to move under the Object List pane. (The pane shows all tables)
    5. Right-click the tables and choose Manage Group -> Move To -> "the folder name you just created".

    Thanks

    Comment

    Working...
    X