ColumnStore Data Definition Statements

You can use most normal statements from the MariaDB data definition language (DDL) with ColumnStore tables. This section lists DDL that differs for ColumnStore compared to normal MariaDB usage.

Title Description
DDL statements that differ for ColumnStore Lists of data definition statements (DDL) that differ from normal MariaDB DDL
ColumnStore Alter Table Modifies existing tables including adding, deleting and renaming columns
ColumnStore Create Procedure Creates a stored routine in ColumnStore
ColumnStore Create Table Create multiple columns
ColumnStore Drop Table Deletes a table from ColumnStore
ColumnStore Alter View Alters the definition of a view. CREATE OR REPLACE VIEW may also be used t...
ColumnStore Create View Creates a stored query in the MariaDB ColumnStore Syntax CREATE [OR REPLACE] VIEW
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/columnstore-data-definition-statements/