Delta table with Varchar column vs string column

Hongbo
New Contributor III

‎06-30-2023 06:39 AM

Databricks support string data type. But I can still create delta table with varchar data type. Just wonder what is different between delta table with string and delta table with varchar:

-- delta table with string

CREATE TABLE persons(first_name STRING NOT NULL, last_name STRING NOT NULL, nickname STRING,
                       CONSTRAINT person_pk PRIMARY KEY (first_name, last_name)
                       );
-- delta table with varchar
CREATE TABLE persons(first_name STRING NOT NULL, last_name varchar(50) NOT NULL, nickname varchar(50),
                       CONSTRAINT person_pk PRIMARY KEY (first_name, last_name)
                       );