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:
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|