In Databricks (Delta Lake), the syntax to create an auto-incrementing identity column is GENERATED ALWAYS AS IDENTITY or GENERATED BY DEFAULT AS IDENTITY. This ensures each new row receives a unique incrementing integer.