In YCQL the DROP KEYSPACE statement is used remove a keyspace from the system. An error is raised if the specified keyspace […]
Read More
Change a Database User’s SuperUser Status
A database superuser bypasses all permission checks, except the right to log in. This is a dangerous privilege and should not be […]
Read MoreEXPORT TABLE DDL (FROM YSQL)
In YSQL you can display the structure of a table, including indexes and constraints, by issuing the d table_name meta-command. yugabyte=# CREATE […]
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 More