USE

Syntax

USE database

Description

Uses the named database rather than the default database associated with your username. (Microsoft SQL Server only.)

Use USE in the SETUP section only. When used, it must appear at the top of your report, before any queries are defined.

To reference more than one database in a program, specify secondary databases explicitly. For example:

from sqdb.sqr.customers

You cannot issue the Microsoft SQL Server USE command from within an SQL paragraph.

Parameters

Parameter	Description
database	Specifies the name of the database to use.

Example

The following example shows the USE command:

begin-setup
 use pubs
end-setup