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