In YugabyteDB YCQL, the SELECT statement must have a FROM clause. However, some queries don’t require any table. Example: ycqlsh> SELECT currenttimestamp(); […]
Read MoreDisplay the Number of Tablets (Shards) for a Table
By default, YugabyteDB presplits a table in ysql_num_shards_per_tserver * num_of_tserver shards. We can display the number of tablets for a table using the […]
Read MoreDisplay Supported CQL Version
Having its roots in the Cassandra Query Language (CQL), the Yugabyte Cloud Query Language (YCQL) is a semi-relational SQL API that is […]
Read MoreDISPLAY YUGABYTEDB VERSION (WITH YB_VERSION)
The version() built-in function returns both the supported PostgreSQL version and the version of YugabyteDB. If you are just interested in the […]
Read MoreDROP ALL TABLES IN A SCHEMA
While there isn’t a single command to drop all tables in a schema, you can easily accomplish that task by generating and […]
Read More