Appearance
Show Database
Shows the active database.
Permissions
| Command Kind | Needed User Kind |
|---|---|
| Read | Admin, Sys, SysTech |
Parameters
None
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 scripts. |
| Texts | integer | Number of database texts. |
| 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 DATABASE