Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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:
Table locks are only 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 table locks
Intent to write table locks
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|