Databricks SQL CREATE TABLE ParseException

Sid0610
New Contributor II

I am trying to use the following code to create a deltatable

%sql

CREATE TABLE rectangles(a INT, b INT, area INT GENERATED ALWAYS AS IDENTITY (START WITH 1, STEP BY 1))

I don't know why but I am always getting the ParseException error.

I tried all other combinations as well such as - CREATE TABLE rectangles(a INT, b INT, area INT GENERATED ALWAYS AS IDENTITY (1, 1)), etc

Error:

ParseException:

extraneous input 'IDENTITY' expecting '('(line 1, pos 67)

Priyag1
Honored Contributor II

What is parse exception?

emiratesevisaon
New Contributor II

How can we use SQL for my website emiratesevisaonline.com backend date?