4D v14

LOCK TABLE

Home

 
Home
4D v14
4D SQL Reference
SQL Commands
LOCK TABLE

LOCK TABLE  


 

 

 Command LOCK TABLLOCK TABLE sql_name IN {EXCLUSIVE | SHARE} MODE

The LOCK TABLE command is used to lock the table named sql_name in either EXCLUSIVE or SHARE mode.

In EXCLUSIVE mode, the data of the table cannot be read or modified by another transaction.

In SHARE mode, the data of the table can be read by concurrent transactions but modifications are still prohibited.

Example  

This example locks the MOVIES table so that it can be read but not modified by other transactions:

LOCK TABLE MOVIES IN SHARE MODE

 
PROPERTIES 

Product: 4D
Theme: SQL Commands

 
SEE ALSO 

ALTER TABLE
UNLOCK TABLE

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)