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