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