In YSQL you can query the system table INFORMATION_SCHEMA.COLUMNS to list details about each of the columns in table. Example: yugabyte=# CREATE […]
Read MoreIn YSQL you can query the system table INFORMATION_SCHEMA.COLUMNS to list details about each of the columns in table. Example: yugabyte=# CREATE […]
Read MoreBy 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 MoreThe version() built-in function returns both the supported PostgreSQL version and the version of YugabyteDB. If you are just interested in the […]
Read MoreWhile there isn’t a single command to drop all tables in a schema, you can easily accomplish that task by generating and […]
Read MoreA unique index disallows duplicate values from being inserted into the indexed columns. But this does not apply to NULL values. Here […]
Read More