Schema locks serialize changes to a database schema, and ensure that transactions using a table are not affected by schema changes initiated by other connections. For example, a shared schema lock prevents an ALTER TABLE statement from dropping a column from a table when that table is being read by an open cursor on another connection.
There are two classes of schema locks: shared and exclusive.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|