Skip to content
Snippets Groups Projects
Select Git revision
  • sd/exec
  • 2.11.5-picodata default protected
  • funbringer/2.11.5-fix-select-param-having
  • sd/small_tuple
  • sd/tuple_buf
  • sd/execute_result
  • gmoshkin/more-backports
  • gmoshkin/more-backports-WIP
  • sd/64-bit
  • sd/wf_fixups protected
  • sd/c813750b7
  • funbringer/2.11.5-extend-op-result-row
  • gmoshkin/fix-window-in-subquery protected
  • sd/fix_r10
  • sd/window
  • sd/fix_sq
  • sd/fix_window_sq_panic
  • picodata-25.1
  • ekhamitov/sd/window-v2
  • vshunkov/fix_path protected
  • 2.11.5 protected
  • 2.11.2.159 protected
  • 2.11.4 protected
  • 2.11.2.155 protected
  • 2.11.2.148 protected
  • 2.11.2.145 protected
  • 2.11.2.137 protected
  • 2.11.2.136 protected
  • 2.11.2.135 protected
  • 2.11.3 protected
  • 2.11.2.109 protected
  • 2.11.2.108 protected
  • 2.11.2.105 protected
  • 2.11.2.98 protected
  • 2.11.2.97 protected
  • 2.11.2.96 protected
  • 2.11.2.92 protected
  • 2.11.2 protected
  • 3.0.0-beta1 protected
  • 2.11.0.91 protected
40 results
Compare
user avatar
sql: introduce SHOW CREATE TABLE statement
Mergen Imeev authored 
This patch introduces the SHOW CREATE TABLE statement. This statement
can be used to obtain a description of a space in the form of a
corresponding CREATE TABLE and CREATE INDEX statements.

Closes #8098

@TarantoolBot document
Title: SHOW CREATE TABLE statement

Statement can be used to obtain a description of a space in the form of
a corresponding `CREATE TABLE` and `CREATE INDEX` statements. Result
will be in form of set of statements and set of found errors. If errors
were not detected, set of the statements should be enough to completely
serialize space definition.

There is two types of `SHOW CREATE TABLE` statement:
1) Get a description of a single space:
```
SHOW CREATE TABLE table_name;
```

This statement can be used to obtain a description of a space in the
form of the corresponding `CREATE TABLE` and `CREATE INDEX` statements.
The result will be in the form of a set of statements and a set of found
errors. If no errors are found, the set of statements should be
sufficient to fully serialize the space definition. Otherwise, it will
certainly not be a complete space definition, and a `CREATE TABLE`
statement is generally not guaranteed to be syntactically correct.

2) Get descriptions of all available non-system spaces:
```
SHOW CREATE TABLE;
```

This statement returns descriptions for each available non-system space
in the form described above.
5ab5ce2a
History
user avatar 5ab5ce2a
History
Name Last commit Last update
.github
FreeBSD/databases/tarantool
apk
asan
changelogs/unreleased
cmake
debian
doc
extra
perf
rpm
rump
src
static-build
test
third_party
tools
test-run @ 02c48288
.editorconfig
.gdbinit
.gitattributes
.gitignore
.gitmodules
.luacheckrc
.pack.mk
.test.mk
AUTHORS
CMakeLists.txt
CONTRIBUTING.md
Doxyfile
Doxyfile.API.in
LICENSE
README.FreeBSD
README.MacOSX
README.OpenBSD
README.md
TODO
README.md

Tarantool

Actions Status Code Coverage OSS Fuzz Telegram GitHub Discussions Stack Overflow

Tarantool is an in-memory computing platform consisting of a database and an application server.

It is distributed under BSD 2-Clause terms.

Key features of the application server:

Key features of the database:

  • MessagePack data format and MessagePack based client-server protocol.
  • Two data engines: 100% in-memory with complete WAL-based persistence and an own implementation of LSM-tree, to use with large data sets.
  • Multiple index types: HASH, TREE, RTREE, BITSET.
  • Document oriented JSON path indexes.
  • Asynchronous master-master replication.
  • Synchronous quorum-based replication.
  • RAFT-based automatic leader election for the single-leader configuration.
  • Authentication and access control.
  • ANSI SQL, including views, joins, referential and check constraints.
  • Connectors for many programming languages.
  • The database is a C extension of the application server and can be turned off.

Supported platforms are Linux (x86_64, aarch64), Mac OS X (x86_64, M1), FreeBSD (x86_64).

Tarantool is ideal for data-enriched components of scalable Web architecture: queue servers, caches, stateful Web applications.

To download and install Tarantool as a binary package for your OS or using Docker, please see the download instructions.

To build Tarantool from source, see detailed instructions in the Tarantool documentation.

To find modules, connectors and tools for Tarantool, check out our Awesome Tarantool list.

Please report bugs to our issue tracker. We also warmly welcome your feedback on the discussions page and questions on Stack Overflow.

We accept contributions via pull requests. Check out our contributing guide.

Thank you for your interest in Tarantool!