Using database connections in the SQL editor

When you open an SQL scrapbook page in the SQL editor, the page might not have a connection to a database. If you want to use content assist to help you specify tables and columns in SQL statements, you must have a database connection

If you are connected to a database, you can disconnect from the database and then connect to a different database.

Prerequisite: To use a database connection, the SQL scrapbook page must be open in the SQL editor.

To use a database connection in the SQL editor:
To connect to a database
  1. Right-click in the SQL editor, and then click Connect to Database on the pop-up menu.
  2. Complete the pages in the Connection Selection wizard, and then click Finish.
To disconnect from a database Right-click in the SQL editor, and then click Disconnect from Database on the pop-up menu.
Related tasks
Creating SQL scrapbook pages
Modifying SQL scrapbook pages in the SQL editor