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

1. SHOW VSCHEMA TABLES

Shows tables in VSchema.

SHOW VSCHEMA VINDEXES

1. SHOW VSCHEMA VINDEXES

Shows all vindexes in VSchema.

SHOW VSCHEMA VINDEXES FROM tbl_name

1. SHOW VSCHEMA VINDEXES [FROM | ON] tbl_name

Shows vindexes from table tbl_name in VSchema.

ALTER VSCHEMA ADD TABLE

1. 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

1. ALTER VSCHEMA DROP TABLE {keyspace_name.tbl_name | tbl_name}

Drops the table from the VSchema for the current keyspace.

ALTER VSCHEMA CREATE VINDEX

1. ALTER VSCHEMA CREATE VINDEX vindex_name USING vindex_type [WITH vindex_option[, vindex_option] ...]

3. vindex_option: {
4. name = value
5. }

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

1. ALTER VSCHEMA DROP VINDEX vindex_name

Drops a vindex from the VSchema.

ALTER VSCHEMA ON tbl_name ADD VINDEX

1. 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

1. ALTER VSCHEMA ON tbl_name REMOVE VINDEX tbl_name.vindex_name

Removes a vindex from table tbl_name.

ALTER VSCHEMA ADD SEQUENCE

1. ALTER VSCHEMA ADD SEQUENCE tbl_name.seq_name

ALTER VSCHEMA DROP SEQUENCE

1. ALTER VSCHEMA DROP SEQUENCE tbl_name.seq_name

ALTER VSCHEMA ON … ADD AUTO_INCREMENT

1. ALTER VSCHEMA ON tbl_name ADD AUTO_INCREMENT column_name USING tbl_name.seq_name

ALTER VSCHEMA ON … DROP AUTO_INCREMENT

1. ALTER VSCHEMA ON tbl_name DROP AUTO_INCREMENT