CREATE TABLE

In the Ultra Transcenders books

DBX-DEP

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

Terms in this definition

• Event

  Table in Log Analytics where entries from Windows event logs are kept.

• General-purpose v1

  The older storage account kind (Storage), which lacks access tiers, Archive and premium file shares and retires on 13 October 2026. Converting to ZRS requires first upgrading to GPv2, a one-way change.

• FORMAT

  A DAX function that turns a value into text according to a format string, for instance "MMMM" to show a month's name. Since the output is text, numeric operations can't use it, and dynamic format strings were introduced to get around that.

• KEYS

  Lists the column or columns that identify each target row uniquely in an AUTO CDC statement.

• Table options

  Set only at creation with OPTIONS, these key-value storage settings can't be altered or dropped afterwards; on Delta tables they also show up among the table properties.

• Veeam Infrastructure Appliance

  A hardened, minimal Linux (JeOS) ISO for running backup proxies, repositories and hardened repositories. It connects to a backup server but does not host one.

• 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.

Related terms

• CLONE

  Copies a table as of a given version through CREATE TABLE ... CLONE. Deep is the default and duplicates data plus metadata; shallow copies the metadata alone and keeps referencing the original files.

• Data clustering

  A Fabric Data Warehouse preview capability that, as data is loaded, keeps rows with similar values in up to four chosen columns physically together, letting filtered queries avoid reading irrelevant files. You set it once with WITH (CLUSTER BY (...)) in CREATE TABLE or CTAS and cannot alter it afterwards; lakehouse Delta liquid clustering is a different feature.

• Node table

  In SQL Graph, a table representing entities, made with CREATE TABLE ... AS NODE. Every row automatically carries a \$node_id pseudo-column; connections between nodes are stored in edge tables.