Difference between revisions of "Commands"
Jump to navigation
Jump to search
Line 2: | Line 2: | ||
Database commands can be either run from the [[Startup_Options#BaseX_Standalone|Command Line]], | Database commands can be either run from the [[Startup_Options#BaseX_Standalone|Command Line]], | ||
the [[Language Bindings]], [[JAX-RX]], the input field in the [[GUI_Tutorial|GUI]], or | the [[Language Bindings]], [[JAX-RX]], the input field in the [[GUI_Tutorial|GUI]], or | ||
− | in many other ways. | + | in many other ways. The [[User_Management#Command_Permissions|Permission]] in the command |
− | [[User_Management#Command_Permissions| | + | definitions indicates which rights are required by a user to perform a command in the |
+ | client/server architecture. | ||
If the GUI is used, all commands that are triggered by the GUI itself will show up in the [[GUI_Views|Info View]]. | If the GUI is used, all commands that are triggered by the GUI itself will show up in the [[GUI_Views|Info View]]. | ||
Line 13: | Line 14: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>ADD (AS [name]) (TO [target]) [input]</code> | |<code>ADD (AS [name]) (TO [target]) [input]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>WRITE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 29: | Line 33: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>ALTER DATABASE [name] [newname]</code> | |<code>ALTER DATABASE [name] [newname]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 42: | Line 49: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>ALTER USER [name] ([password])</code> | |<code>ALTER USER [name] ([password])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 51: | Line 61: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>BACKUP [name]</code> | |<code>BACKUP [name]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 60: | Line 73: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>CHECK [input]</code> | |<code>CHECK [input]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 69: | Line 85: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>CLOSE </code> | |<code>CLOSE </code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>NONE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 78: | Line 97: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>COPY [name] [newname]</code> | |<code>COPY [name] [newname]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 87: | Line 109: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>CREATE DATABASE [name] ([input])</code> | |<code>CREATE DATABASE [name] ([input])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 96: | Line 121: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>CREATE INDEX [TEXT|ATTRIBUTE|FULLTEXT|PATH]</code> | |<code>CREATE INDEX [TEXT|ATTRIBUTE|FULLTEXT|PATH]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>WRITE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 105: | Line 133: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>CREATE USER [name] ([password])</code>: | |<code>CREATE USER [name] ([password])</code>: | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 114: | Line 145: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>CS [query]</code> | |<code>CS [query]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |''depends on query'' | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 123: | Line 157: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>DELETE [path]</code> | |<code>DELETE [path]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>WRITE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 132: | Line 169: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>DROP BACKUP [name]</code> | |<code>DROP BACKUP [name]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 141: | Line 181: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>DROP DATABASE [name]</code> | |<code>DROP DATABASE [name]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 150: | Line 193: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>DROP INDEX [PATH|TEXT|ATTRIBUTE|FULLTEXT]</code> | |<code>DROP INDEX [PATH|TEXT|ATTRIBUTE|FULLTEXT]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>WRITE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 159: | Line 205: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>DROP USER [name] (ON [database])</code>: | |<code>DROP USER [name] (ON [database])</code>: | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 168: | Line 217: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>EXIT </code> | |<code>EXIT </code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>NONE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 177: | Line 229: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>EXPORT [path]</code> | |<code>EXPORT [path]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 186: | Line 241: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>FIND [keywords]</code> | |<code>FIND [keywords]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>READ</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 196: | Line 254: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>GET [option]</code> | |<code>GET [option]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>NONE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 205: | Line 266: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>GRANT [NONE|READ|WRITE|CREATE|ADMIN] (ON [database]) TO [user]</code> | |<code>GRANT [NONE|READ|WRITE|CREATE|ADMIN] (ON [database]) TO [user]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 214: | Line 278: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>HELP ([command])</code> | |<code>HELP ([command])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>NONE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 223: | Line 290: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>INFO</code> | |<code>INFO</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>READ</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 232: | Line 302: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>INFO DATABASE</code> | |<code>INFO DATABASE</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>READ</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 241: | Line 314: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>INFO INDEX ([TEXT|ATTRIBUTE|FULLTEXT|PATH])</code> | |<code>INFO INDEX ([TEXT|ATTRIBUTE|FULLTEXT|PATH])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>READ</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 251: | Line 327: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>INFO STORAGE [start end] | [query]</code> | |<code>INFO STORAGE [start end] | [query]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>READ</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 260: | Line 339: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>KILL [name]</code> | |<code>KILL [name]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 269: | Line 351: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>LIST ([path])</code> | |<code>LIST ([path])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>NONE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 278: | Line 363: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>OPEN [path]</code> | |<code>OPEN [path]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>READ</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 287: | Line 375: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>OPTIMIZE (ALL)</code> | |<code>OPTIMIZE (ALL)</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>WRITE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 296: | Line 387: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>PASSWORD ([password])</code> | |<code>PASSWORD ([password])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>NONE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 305: | Line 399: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>RESTORE [name]</code> | |<code>RESTORE [name]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 314: | Line 411: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>RUN [file]</code> | |<code>RUN [file]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |''depends on query'' | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 324: | Line 424: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>SET [option] ([value])</code> | |<code>SET [option] ([value])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>NONE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 333: | Line 436: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>SHOW BACKUPS</code> | |<code>SHOW BACKUPS</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>CREATE</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 342: | Line 448: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>SHOW DATABASES</code> | |<code>SHOW DATABASES</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 351: | Line 460: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>SHOW SESSIONS</code> | |<code>SHOW SESSIONS</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 360: | Line 472: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>SHOW USERS (ON [database])</code> | |<code>SHOW USERS (ON [database])</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |<code>ADMIN</code> | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' | ||
Line 369: | Line 484: | ||
| valign='top' width='90' | '''Signature''' | | valign='top' width='90' | '''Signature''' | ||
|<code>XQUERY [query]</code> | |<code>XQUERY [query]</code> | ||
+ | |- | ||
+ | | valign='top' | '''Permission''' | ||
+ | |''depends on query'' | ||
|- | |- | ||
| valign='top' | '''Summary''' | | valign='top' | '''Summary''' |
Revision as of 02:36, 6 May 2011
This page lists all database commands that are supported by BaseX. Database commands can be either run from the Command Line, the Language Bindings, JAX-RX, the input field in the GUI, or in many other ways. The Permission in the command definitions indicates which rights are required by a user to perform a command in the client/server architecture.
If the GUI is used, all commands that are triggered by the GUI itself will show up in the Info View.
A short version exists for some command arguments. For example, you may replace the DATABASE
keyword with DB
.
Contents
- 1 ADD
- 2 ALTER DATABASE
- 3 ALTER USER
- 4 BACKUP
- 5 CHECK
- 6 CLOSE
- 7 COPY
- 8 CREATE DATABASE
- 9 CREATE INDEX
- 10 CREATE USER
- 11 CS
- 12 DELETE
- 13 DROP BACKUP
- 14 DROP DATABASE
- 15 DROP INDEX
- 16 DROP USER
- 17 EXIT
- 18 EXPORT
- 19 FIND
- 20 GET
- 21 GRANT
- 22 HELP
- 23 INFO
- 24 INFO DATABASE
- 25 INFO INDEX
- 26 INFO STORAGE
- 27 KILL
- 28 LIST
- 29 OPEN
- 30 OPTIMIZE
- 31 PASSWORD
- 32 RESTORE
- 33 RUN
- 34 SET
- 35 SHOW BACKUPS
- 36 SHOW DATABASES
- 37 SHOW SESSIONS
- 38 SHOW USERS
- 39 XQUERY
ADD
Signature | ADD (AS [name]) (TO [target]) [input]
|
Permission | WRITE
|
Summary | Adds the files, directory or XML string specified by [input] to the currently opened database, using an optional [target] path and an optional file [name] .The input may either be a single XML document, a directory, a remote URL or a plain XML string. The optional name is ignored if the input is a directory. |
Examples |
|
ALTER DATABASE
Signature | ALTER DATABASE [name] [newname]
|
Permission | CREATE
|
Summary | Alters the [name] of a database to [newname] .
|
Examples |
|
ALTER USER
Signature | ALTER USER [name] ([password])
|
Permission | ADMIN
|
Summary | Alters the [password] of the user specified with [name] . If no password is specified in the console mode, it is requested via standard input.
|
BACKUP
Signature | BACKUP [name]
|
Permission | CREATE
|
Summary | Creates a zipped backup of the specified database. The backup file will be suffixed with the current timestamp. |
CHECK
Signature | CHECK [input]
|
Permission | CREATE
|
Summary | Opens an existing database for the specified [input] or creates a new instance.
|
CLOSE
Signature | CLOSE
|
Permission | NONE
|
Summary | Closes the currently opened database. |
COPY
Signature | COPY [name] [newname]
|
Permission | CREATE
|
Summary | Creates a copy of the database specified by [name] .
|
CREATE DATABASE
Signature | CREATE DATABASE [name] ([input])
|
Permission | CREATE
|
Summary | Creates the database [name] with an optional [input] .The input may either be a single XML document, a directory, a remote URL or a plain XML string. |
CREATE INDEX
Signature | CREATE INDEX [TEXT|ATTRIBUTE|FULLTEXT|PATH]
|
Permission | WRITE
|
Summary | Creates the specified database index. |
CREATE USER
Signature | CREATE USER [name] ([password]) :
|
Permission | ADMIN
|
Summary | Creates a user with the specified [name] and [password] . If no password is specified in the console mode, it is requested via standard input.
|
CS
Signature | CS [query]
|
Permission | depends on query |
Summary | Evaluates the specified [query] and sets the result as new context set.
|
DELETE
Signature | DELETE [path]
|
Permission | WRITE
|
Summary | Deletes all documents from the currently opened database that start with the specified [path] .
|
DROP BACKUP
Signature | DROP BACKUP [name]
|
Permission | CREATE
|
Summary | Drops all backups for the database with the specified [name] .
|
DROP DATABASE
Signature | DROP DATABASE [name]
|
Permission | CREATE
|
Summary | Drops the database with the specified [name] .
|
DROP INDEX
Signature | DROP INDEX [PATH|TEXT|ATTRIBUTE|FULLTEXT]
|
Permission | WRITE
|
Summary | Drops the specified database index. |
DROP USER
Signature | DROP USER [name] (ON [database]) :
|
Permission | ADMIN
|
Summary | Drops the user with the specified [name] . If a [database] is specified, the user is only dropped locally.
|
EXIT
Signature | EXIT
|
Permission | NONE
|
Summary | Exits the console mode. |
EXPORT
Signature | EXPORT [path]
|
Permission | CREATE
|
Summary | Exports all documents in the database to the specified [path] .
|
FIND
Signature | FIND [keywords]
|
Permission | READ
|
Summary | Builds and runs a query for the specified [keywords] . The following modifiers can be used to further limit search:
|
GET
Signature | GET [option]
|
Permission | NONE
|
Summary | Returns the value of the specified [option] . A list of all options is available here.
|
GRANT
Signature | GRANT [NONE|READ|WRITE|CREATE|ADMIN] (ON [database]) TO [user]
|
Permission | ADMIN
|
Summary | Grants the specified permission to the specified [user] . If a [database] is specified, the permissions are only granted locally.
|
HELP
Signature | HELP ([command])
|
Permission | NONE
|
Summary | If [command] is specified, information on the specific command is printed; otherwise, all commands are listed.
|
INFO
Signature | INFO
|
Permission | READ
|
Summary | Shows global information. |
INFO DATABASE
Signature | INFO DATABASE
|
Permission | READ
|
Summary | Shows information on the currently opened database. |
INFO INDEX
Signature | ATTRIBUTE|FULLTEXT|PATH]) |
Permission | READ
|
Summary | Shows information on the existing index structures. The output can be optionally limited to the specified index. |
INFO STORAGE
Signature | [query] |
Permission | READ
|
Summary | Shows the internal main table of the currently opened database. |
KILL
Signature | KILL [name]
|
Permission | ADMIN
|
Summary | Kills all sessions of the user specified by [name] .
|
LIST
Signature | LIST ([path])
|
Permission | NONE
|
Summary | Lists all available databases, or the documents in a database. [path] is the name of the database, optionally followed by a path to the requested documents.
|
OPEN
Signature | OPEN [path]
|
Permission | READ
|
Summary | Opens the documents in a database. [path] is the name of the database, optionally followed by a path to the requested documents.
|
OPTIMIZE
Signature | OPTIMIZE (ALL)
|
Permission | WRITE
|
Summary | Optimizes the current database structures. If the ALL flag is specified, the size of all database files is minimized.
|
PASSWORD
Signature | PASSWORD ([password])
|
Permission | NONE
|
Summary | Changes the [password] of the current user. If no password is specified in the console mode, it is requested via standard input.
|
RESTORE
Signature | RESTORE [name]
|
Permission | CREATE
|
Summary | Restores a database with the specified [name] . The name may include the timestamp of the backup file.
|
RUN
Signature | RUN [file]
|
Permission | depends on query |
Summary | Runs the query contained in [file] and prints the result.
|
SET
Signature | SET [option] ([value])
|
Permission | NONE
|
Summary | Sets an [option] to the specified [value] . A list of all options is available here.
|
SHOW BACKUPS
Signature | SHOW BACKUPS
|
Permission | CREATE
|
Summary | Shows all database backups. |
SHOW DATABASES
Signature | SHOW DATABASES
|
Permission | ADMIN
|
Summary | Shows all databases that are opened in the current server instance. |
SHOW SESSIONS
Signature | SHOW SESSIONS
|
Permission | ADMIN
|
Summary | Shows all sessions that are connected to the current server instance. |
SHOW USERS
Signature | SHOW USERS (ON [database])
|
Permission | ADMIN
|
Summary | Shows all users that are registered in the database. If a [database] is specified, local users are shown.
|
XQUERY
Signature | XQUERY [query]
|
Permission | depends on query |
Summary | Runs the specified [query] and prints the result.
|
Examples |
|