APPLY Topology
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