The UPDATE statement modifies the values of specified columns in all rows that meet certain conditions. When no conditions are specified in […]
Read MoreChange the Owner of a View in YSQL
When a CREATE VIEW statement is issued in a session, the view’s ownership is assigned to the current session user. Example: yugabyte=# […]
Read MoreChange the Owner of a Sequence in YSQL
When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreCheck for Invalid Indexes in YSQL
If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read MoreConsolidate Data From YB Catalog Tables From All Nodes To One Node
System catalogs, also referred to as system tables or system views, are essential to the internal structure and management of the database, […]
Read More