Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects » Working with databases

Displaying system objects in a database Next Page

Logging SQL statements


As you work with a database in Sybase Central, the application automatically generates SQL statements depending on your actions. You can keep track of these statements in a separate pane, called Server Messages and Executed SQL or save the information to a file. The Server Messages and Executed SQL pane has a tab for each database and database server. The tab for database servers contains the same information as the Server Messages window.

When you work with Interactive SQL, you can also log statements that you execute.

For more information, see Logging commands.

To log SQL statements generated by Sybase Central
  1. From the View menu, choose Server Messages and Executed SQL.

    The Server Messages and Executed SQL pane appears at the bottom of the Sybase Central window.

  2. Right-click in the Server Messages and Executed SQL pane and choose Options from the popup menu.

    The Options dialog appears.

  3. In the resulting dialog, specify the desired settings. If you want to save the logging information to a file, click Save.