Menu
I tried using Oracle's DESCRIBE TABLE... statement in CockroachDB and got a syntax error. What’s the equivalent command?
664
Describes either the columns in a table or the current values, as well as the default values, for the stage properties for a table. DESCRIBE can be abbreviated to DESC.
CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store.
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.
150
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With