When the database server automatically locks a table

The database server always locks an entire table while it performs operations for any of the following statements:
  • ALTER FRAGMENT
  • ALTER INDEX
  • ALTER TABLE
  • CREATE INDEX
  • DROP INDEX
  • RENAME COLUMN
  • RENAME TABLE

Completion of the statement (or end of the transaction) releases the lock. An entire table can also be locked automatically during certain queries.