Tools SQL-Editor Estimated reading: 1 minute This menu item allows direct access to the database. When started, all tables in the database are listed below the ‘Input fields’ with type and date. When entering a different request, the corresponding result is displayed. Tables Info ‘Info’ lists database-specific information about the fields (columns) of the selected table. Select a table using the drop down list of the input field ‘Tables’. Show The records of the selected table are displayed with the contents of all fields stored in the data base, including the LIMBAS internal fields. Empty All Data records of the table selected in the ‘select field’ will be deleted Caution: with LIMBAS Systemtables !! Delete The table selected in the ‘select field’ will be deleted. Caution: with LIMBAS Systemtables !! System Info Select a System Table using the drop down list of the input field ‘System Information’. Which system tables are available, depends on the database used. SQL Query Any SQL statements specified in the text box, which are supported by the database, can be carried out. Ctrl+Space: SQL-keyword autocomplete Ctrl+Return: Run query Automatic Formatting If you enter an unformatted code into the Limbas SQL-Editor, it will be formatted automatically.
