VSchema DDL

VSchema DDL is an experimental feature that allows users to alter the VSchema by issuing “vschema ddls” directly to vtgate. The vschema_ddl_authorized_users flag specifies which users can alter the vschema.

SHOW VSCHEMA TABLES

SHOW VSCHEMA TABLES

Shows tables in VSchema.

SHOW VSCHEMA VINDEXES

SHOW VSCHEMA VINDEXES

Shows all vindexes in VSchema.

SHOW VSCHEMA VINDEXES FROM tbl_name

SHOW VSCHEMA VINDEXES [FROM | ON] tbl_name

Shows vindexes from table tbl_name in VSchema.

ALTER VSCHEMA ADD TABLE

ALTER VSCHEMA ADD TABLE {keyspace_name.tbl_name | tbl_name}

Adds the given table to the VSchema for the current keyspace.

ALTER VSCHEMA DROP TABLE

ALTER VSCHEMA DROP TABLE {keyspace_name.tbl_name | tbl_name}

Drops the table from the VSchema for the current keyspace.

ALTER VSCHEMA CREATE VINDEX

ALTER VSCHEMA CREATE VINDEX vindex_name USING vindex_type [WITH vindex_option[, vindex_option] ...]
vindex_option: {
  name = value
}

Creates a vindex with the specified vindex_type and vindex_options.

For the various vindex types and vindex options see Vindexes documentation.

ALTER VSCHEMA DROP VINDEX

ALTER VSCHEMA DROP VINDEX vindex_name

Drops a vindex from the VSchema.

ALTER VSCHEMA ON tbl_name ADD VINDEX

ALTER VSCHEMA ON tbl_name ADD VINDEX tbl_name.vindex_name (column_name[, column_name] ...) [USING vindex_type] [WITH vindex_option[, vindex_option] ...]

Adds a vindex for table tbl_name and columns column_name.

For the various vindex types and vindex options see Vindexes documentation.

ALTER VSCHEMA ON tbl_name REMOVE VINDEX

ALTER VSCHEMA ON tbl_name REMOVE VINDEX tbl_name.vindex_name

Removes a vindex from table tbl_name.

ALTER VSCHEMA ADD SEQUENCE

ALTER VSCHEMA ADD SEQUENCE tbl_name.seq_name

ALTER VSCHEMA DROP SEQUENCE

ALTER VSCHEMA DROP SEQUENCE tbl_name.seq_name

ALTER VSCHEMA ON … ADD AUTO_INCREMENT

ALTER VSCHEMA ON tbl_name ADD AUTO_INCREMENT column_name USING tbl_name.seq_name

ALTER VSCHEMA ON … DROP AUTO_INCREMENT

ALTER VSCHEMA ON tbl_name DROP AUTO_INCREMENT