Operations that 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