SQL monitor
This site provides direct, easy access to databases linked via the DatabaseService.
Attention: There is no security check or anything similar. All statements are passed on to the database without modification, so damage to the database or the stored data can be done. Appropriate caution is therefore required.
(1) Specification of the SqlService. Usually SqlService.
(2) The alias of the database you want to use.
(3) Input field for the SQL statement. If the statement returns a result (e.g. a SELECT), the result set is displayed in (6) after the statement has been executed.
Note: In the WHERE part of the query, parameters of the form @1:s@ can be used. When the query is started, another dialogue will then appear where you can specify values for these parameters. The first part in the parameter is the parameter number (integer, starting from 0). The second part after the colon is the data type. Allowed data types:
|
Abbreviation |
Data type |
|
i |
Integer |
|
f |
Float |
|
r |
Real |
|
d |
Date |
|
t |
Timestamp |
|
s |
String |
|
l |
Long |
|
v |
Boolean |
|
b |
Blob |
|
x |
Textstream |
(4) This executes the entered SQL statement.
(5) To prevent the browser from being overwhelmed with too much data in the display, the result set can be restricted. The maximum number of lines is set to 100 by default.
(6) The result set of the executed SQL statement.
(7) See the following screenshot. A list of the tables defined in the database is displayed. The meaning of the columns corresponds to that of the result set when calling the getTables function of the JDBC driver.
