Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Transactions and isolation levels » How locking works


Table locks

In addition to locks on rows, SQL Anywhere also supports locks on tables. Table locks are different than schema locks: a table lock places a lock on all the rows in the table, as opposed to a lock on the table's schema. There are three types of table locks: shared, intent to write, and exclusive.

Table locks are released at the end of a transaction when a COMMIT or ROLLBACK occurs.

The following table identifies the combinations of table locks that conflict:

Shared Intent Exclusive
Shared conflict conflict
Intent conflict conflict
Exclusive conflict conflict conflict
 Shared table locks
 Intent to write table locks
 Exclusive table locks
 See also