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 MoreLimit Column to a Single NULL Value
A unique index disallows duplicate values from being inserted into the indexed columns. But this does not apply to NULL values. Here […]
Read MoreCLOSE ALL USER SESSIONS
You might need to close all user sessions connected to a YugabyteDB database if, for example, there is severe resource contention or […]
Read More