Zen

Source string Source string

131/10000 · 131
English Actions
SQL statements and clauses
The Statements and Clauses guide shows all Tarantool/SQL statements' syntax and use.
Heading
Summary
:ref:`Statements that change data definition <sql_statements_change_definition>`
:ref:`ALTER TABLE <sql_alter_table>`, :ref:`CREATE TABLE <sql_create_table>`, :ref:`DROP TABLE <sql_drop_table>`, :ref:`CREATE VIEW <sql_create_view>`, :ref:`DROP VIEW <sql_drop_view>`, :ref:`CREATE INDEX <sql_create_index>`, :ref:`DROP INDEX <sql_drop_index>`, :ref:`CREATE TRIGGER <sql_create_trigger>`, :ref:`DROP TRIGGER <sql_drop_trigger>`
:ref:`Statements that change data <sql_statements_change_data>`
:ref:`INSERT <sql_insert>`, :ref:`UPDATE <sql_update>`, :ref:`DELETE <sql_delete>`, :ref:`REPLACE <sql_replace>`, :ref:`TRUNCATE <sql_truncate>`, :ref:`SET <sql_set>`
:ref:`Statements that retrieve data <sql_statements_retrieve_data>`
:ref:`SELECT <sql_select>`, :ref:`VALUES <sql_values>`, :ref:`PRAGMA <sql_pragma>`, :ref:`EXPLAIN <sql_explain>`
:ref:`Statements for transactions <sql_transactions>`
:ref:`START TRANSACTION <sql_start_transaction>`, :ref:`COMMIT <sql_commit>`, :ref:`SAVEPOINT <sql_savepoint>`, :ref:`RELEASE SAVEPOINT <sql_release_savepoint>`, :ref:`ROLLBACK <sql_rollback>`
:ref:`Functions <sql_functions>`
For example :ref:`CAST(...) <sql_function_cast>`, :ref:`LENGTH(...) <sql_function_length>`, :ref:`VERSION() <sql_function_version>`
Statements that change data definition
ALTER TABLE
Syntax:
:samp:`ALTER TABLE {table-name} RENAME TO {new-table-name};`
:samp:`ALTER TABLE {table-name} ADD COLUMN {column-name} {column-definition};`
:samp:`ALTER TABLE {table-name} ADD CONSTRAINT {constraint-name} {constraint-definition};`
:samp:`ALTER TABLE {table-name} DROP CONSTRAINT {constraint-name};`
:samp:`ALTER TABLE {table-name} ENABLE|DISABLE CHECK CONSTRAINT {constraint-name};`
|br|
ALTER is used to change a table's name or a table's elements.
**Examples:**
For renaming a table with ``ALTER ... RENAME``, the *old-table* must exist, the *new-table* must not exist. Example: |br| ``-- renaming a table:`` ``ALTER TABLE t1 RENAME TO t2;``
For adding a :ref:`column <sql_column_def>` with ``ADD COLUMN``, the table must exist, the table must be empty, the column name must be unique within the table. Example with a STRING column that must start with X:
ALTER TABLE t1 ADD COLUMN s4 STRING CHECK (s4 LIKE 'X%');
``ALTER TABLE ... ADD COLUMN`` support was added in version :doc:`2.7.1 </release/2.7.1>`.

Loading…

User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_statements_and_clauses — English

For example :ref:`CAST(...) <sql_function_cast>`, :ref:`LENGTH(...) <sql_function_length>`, :ref:`VERSION() <sql_function_version>`
a year ago
Browse all string changes

Things to check

Ellipsis

The string uses three dots (...) instead of an ellipsis character (…)

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
String age
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
string 14