DESCRIBE

Display the schema of a table.

Syntax

DESCRIBE <catalog>.<schema>.<table>

DESC <catalog>.<schema>.<table>

Parameters

Parameter	Description
catalog	The Lance catalog name.
schema	The schema name.
table	The table name.

Example

DESCRIBE lance.default.users;

Using short form:

DESC lance.default.orders;

Output

Column	Type	Extra	Comment
id	bigint
name	varchar
email	varchar

SHOW CREATE TABLE

Display the CREATE TABLE statement for a table.

Syntax

SHOW CREATE TABLE <catalog>.<schema>.<table>

Example

SHOW CREATE TABLE lance.default.users;

Output

CREATE TABLE lance.default.users (
   id bigint,
   name varchar,
   email varchar
)