LOCK TABLE statements

A LOCK TABLE statement ensures that all tables that are involved in a primary transaction are available for update.

A LOCK TABLE statement in a stored procedure that executes by SQL is “implicitly” replicated on a replica. That is, if it is nested in a stored procedure, the stored procedure call is replicated; the LOCK TABLE statement is not replicated. When using table locking in stored procedures against replicated data, be aware that replication might be delayed when applying transactions to the replica. This might happen, for example, if a replica is concurrently running a query against the same tables in a way that conflicts with the requested lock. SELECT statements conflict only with Access Exclusive locks; a LOCK TABLE statement for any mode other than Access Exclusive generally proceeds without delay.