LOCK TABLE

The LOCK TABLE statement either prevents concurrent application processes from changing a table or prevents concurrent application processes from using a table.

You can lock a table:

Example:

Obtain a lock on the DEPARTMENT table. Do not allow others to either update or read from DEPARTMENT while it is locked.

LOCK TABLE DEPARTMENT IN EXCLUSIVE MODE 

For more information, see LOCK TABLE in the SQL Reference topic in the Information CenterLink to Information center.