DESCRIBE TABLE equivalent in CockroachDB?

Question

I tried using Oracle's DESCRIBE TABLE... statement in CockroachDB and got a syntax error. What’s the equivalent command?

Answer 1

In CockroachDB, the SHOW COLUMNS statement returns information about the columns in a table, similar to the DESCRIBE statement in MySQL and the \d command in PostgreSQL:

SHOW COLUMNS FROM tablename;

You can also get some information by running SHOW INDEX or SHOW CREATE TABLE or by querying the information_schema database.