Display Data Using Interactive SQL

Interactive SQL allows you to browse the information in databases.

You can display database information using the select statement in Interactive SQL. Once you enter the statement, click the Execute SQL Statement button on the toolbar.

After you execute the statement, the result set appears in the Results pane. You can use the scroll bars to see areas of the table that are outside your current view of the pane.

For example, to list all the columns and rows of the authors table:
  1. Start Interactive SQL and connect to the pubs2 database.
  2. Enter this in the SQL Statements pane:
    select * from authors
  3. On the toolbar, click the Execute SQL Statement button

    You can add, delete, and update rows within the result set.