Bureaucrats, editor, reviewer, Administrators
13,554
edits
Changes
Jump to navigation
Jump to search
no edit summary
'''<code>ADD (AS [name]) (TO [target]) [input]</code>'''
Adds '''<code>[input]</code>''' as '''<code>[name]</code>''' to the database, using an optional'''<code>[target]</code>''' path.
===ALTER===
Alters user password or database name:
* '''<code>USER [name] ([password])</code>''':
: alters the password of a user.
* '''<code>DATABASE [name] [newname]</code>'''
: alters the name of a database.
Creates a new database, index or user:
* '''<code>DATABASE [name] ([input])</code>''':: creates the database '''<code>[name]</code>''' with an optional '''<code>[input]</code>'''* '''<code>INDEX [TEXT|ATTRIBUTE|FULLTEXT|PATH]</code>''':
: creates the specified index
* '''<code>FS [name] [path] ([mountpoint] [backingstore])</code>''':: creates filesystem database '''<code>[name]</code>''' for '''<code>[path]</code>''': (using '''<code>[mountpoint]</code>''' and '''<code>[backingstore]</code>''' if FUSE is activated)* '''<code>USER [name] ([password])</code>''':
: creates the specified user
Drops a database, index or user:
* '''<code>DATABASE [name]</code>''':
: drops the database
* '''<code>INDEX [PATH|TEXT|ATTRIBUTE|FULLTEXT]</code>''':
: drops the specified index
* '''<code>USER [name]</code>''':
: drops the specified user
* '''<code>BACKUP [name]</code>''':
: drops the database backup
'''<code>EXPORT [path]</code>'''
Exports the database to '''<code>[path]</code>'''.
===FIND===
'''<code>HELP ([command])</code>'''
If '''<code>[command]</code>''' is specified, information on the specific
command is printed; otherwise, all commands are listed.
Shows information on the currently opened database:
* '''<code>no argument</code>''': show global information* '''<code>DATABASE</code>''': shows database information* '''<code>INDEX</code>''': shows index information* '''<code>STORAGE [start end] | [query]</code>''': show internal database table
===KILL===
'''<code>OPEN [name]</code>'''
Opens the specified database '''<code>[name]</code>'''.
===OPTIMIZE===
'''<code>RUN [path]</code>'''
Evaluates an query from '''<code>[path]</code>''' and prints the result.
===SET===
'''<code>SET [option] ([value])</code>'''
Available options '''<code>[option]</code>''' with value '''<code>[value]</code>''' = on/off:* '''<code>QUERYINFO</code>''': Display of query info* '''<code>DEBUG</code>''': Display of debug info* '''<code>SERIALIZE</code>''': Serialization of query results* '''<code>CHOP</code>''': Chopping of XML whitespaces* '''<code>ENTITY</code>''': Parsing of XML entities* '''<code>TEXTINDEX</code>''': Text indexing* '''<code>ATTRINDEX</code>''': Attribute value indexing* '''<code>FTINDEX</code>''': Full-text indexing* '''<code>PATHINDEX</code>''': Path indexing
Have a look into [[Settings]] to find a complete list of available options.
Shows server information:
* '''<code>DATABASES</code>''': shows currently opened databases.* '''<code>SESSIONS</code>''': shows current database sessions.* '''<code>USERS (ON [db])</code>''': shows users (on a database).* '''<code>BACKUPS</code>''': shows backups.
===XQUERY===
