Operations that Take Database Level Locks

The following operations take database level locks:

  • ALTER DATABASE

  • ALTER PIPELINE

  • ALTER TABLE

  • ALTER VIEW

  • BACKUP DATABASE

  • CREATE DATABASE

  • CREATE INDEX

  • CREATE PIPELINE

  • CREATE TABLE

  • CREATE VIEW

  • DROP DATABASE

  • DROP INDEX

  • DROP PIPELINE

  • DROP TABLE

  • DROP VIEW

  • REBALANCE PARTITIONS

  • RESTORE DATABASE

  • RESTORE REDUNDANCY

  • OPTIMIZE TABLE (for rowstore tables only)

  • TRUNCATE

Last modified: September 16, 2022

Was this article helpful?