Skip to main content

Posts

Showing posts from February 5, 2019

CockroachDB Client Command

CockroachDB Client Command In this post, we will learn about some useful cockroach database client command. Start a Local Node Below command will start a local cockroach db node in insecure mode. cockroach start --insecure --port=26257 --http-port=26258 Access Cockroach Shell Below command will give you an access of cockroach db shell. cockroach sql --insecure Display Databases Below command will list all databases of cockroach db node.  SHOW DATABASE; Use Database Below command connect your shell to a particular database. USE databaseName; Display Tables Below command list all tables present in a database. SHOW TABLES; Display Table Structure Below command will display a table definition. SHOW COLUMNS FROM tableName; Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.