APPLY Topology ​

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

Syntax ​

sql
APPLY TOPOLOGY [IN <schema>]

<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