Appearance
Show Databases
Shows the databases of the server.
Permissions
| Command Kind | Needed User Kind |
|---|---|
| Read | Sys, SysTech |
Parameters
| Name | Type | Description | Required | Default | Values |
|---|---|---|---|---|---|
| Find | string | Value to search for in name and captions. | no | ||
| MaxRecords | integer | Maximum number of records to be returned. The default value is 500000. | no | 500000 | |
| Sort | string | Sorts the output by name or caption ([Field].[Caption1]). The field can be [Database]/[Name], [Caption1], [Caption2], [Caption3], [Caption4], [Caption5], [Caption6], [Caption7], [Caption8], [Caption9], [Caption10]. Sort can be Ascending (Asc) or Descending (Desc), e.g. [Caption1].[Ascending] | no |
Result
| Name | Type | Description |
|---|---|---|
| Database | string | Name of the database. |
| Directory | string | Database directory on the server. |
| Loaded | string | Datetime when the database was loaded. |
| Saved | string | Last date and time when the database was saved from memory to disk. |
| SaveEnabled | boolean | If 'True' the database can be saved. It is a temporary value that is not saved in the database settings. |
| Catalog | boolean | If 'True' the database is visible in the 'Show Database Catalog' command. |
| OffsetMonth | integer | Start month of the fiscal year (1=jan. till 12=dec.). |
| WebDirectory | string | Protects a web service directory with 'BasicAuth'. If a value is set, a valid username and password of the database must be used to access the web service directory. E.g. '/MyFiles/SecretFiles/' protects a directory and '/' protects the whole web service. |
| Dimensions | integer | Number of database dimensions. |
| Tables | integer | Number of database tables. |
| Links | integer | Number of database links. |
| Calculations | integer | Number of database calculations. |
| Commands | integer | Number of database commands. |
| CommandGroups | integer | Number of database command groups. |
| Scripts | integer | Number of database texts. |
| Texts | integer | Number of database scripts. |
| UsersTotal | integer | Number of database users (active and inactive). |
| UsersActive | integer | Number of active database users. |
| Roles | integer | Number of database roles. |
| Variables | integer | Number of database variables. |
| Connections | integer | Number of active database connections. |
Code
text
SHOW DATABASES
FIND=[string]
MAXRECORDS=[integer, default=500000]
SORT=[string]