Operations that Take Database Locks

ALTER DATABASE

ALTER TABLE

ALTER VIEW

BACKUP DATABASE

CREATE DATABASE

CREATE INDEX

CREATE TABLE

CREATE VIEW

DROP DATABASE

DROP INDEX

DROP TABLE

DROP VIEW

REBALANCE PARTITIONS

RESTORE DATABASE

RESTORE REDUNDANCY

OPTIMIZE TABLE (for rowstore tables only)

TRUNCATE