DDL

In the Ultra Transcenders books

DP-900DP-750DP-600DP-700DP-800

Each book explains DDL in context, with comparison tables and the common traps.

Terms in this definition

• Serverless

  Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.

• CRUD

  Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.

• DROP

  A DDL (Data Definition Language) statement that deletes a database object like a table. Once a table is dropped, its rows are gone unless a backup exists.

• RENAME

  Gives an existing object in a database, such as a table, a different name; it is a DDL command.

• Schema

  The middle part of a Unity Catalog name (catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached without USE SCHEMA.

• LIKE

  Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.

Related terms

• DQL

  Data query language: SELECT and the other read-only parts of SQL. A Fabric warehouse handles DDL and DML alongside it, while an SQL analytics endpoint is limited to querying.

• IX lock

  The table lock that data-changing statements (INSERT, UPDATE, DELETE, MERGE, COPY INTO) acquire in a Fabric warehouse. Reads take a Sch-S lock while DDL takes a Sch-M lock that blocks everything else, and current locks can be viewed in sys.dm_tran_locks.

• Warehouse

  Fabric item offering complete T-SQL support (DML, DDL, multi-table transactions) over Delta tables held in OneLake; lakehouse SQL analytics endpoints, by contrast, are read-only.