SQL Logfile

From RapidSQL
Jump to: navigation, search

Go Up to Data, Schema, and Miscellaneous Utilities

You can instruct DBArtisan to log all of its SQL statements to a file so that you have an audit trail of application activity. The SQL Logfile captures all the SQL sent by the DBArtisan to populate its editors or to execute your commands. You can use this logfile not only to audit application activity, but also to build SQL scripts for querying system catalogs.

Activating SQL Logging

  1. On the Logfile menu, select Log SQL.

Opening the Logfile

  1. On the Logfile menu, select Open. DBArtisan opens the SQL Logfile into an SQL window.

Logfile Options

You can open the Options Editor from the Logfile menu option and make any changes to your logging options. For details, see Logging Options.

Truncating the Logfile

If the SQL Logfile is growing too large, you can flush it directly from the main menu.

  1. On the Logfile menu, select Truncate. DBArtisan deletes the contents of the SQL Logfile.