To avoid sending COMMIT to each table, you can use this operation:

Syntax

Syntax

APPLY TOPOLOGY [IN <schema>]
SQL

<schema>

You can also decide to use this operation on a specific schema

Output

  • returns the list of tables that requires to be committed

Rights to perform this action

Users are required to be in an admin role to send this command.

If not, the user will get the following error: Error while compiling statement: User XXXX is not in admin role