test connection

Establishes a connection to the database, authenticates, and performs a simple query.

Syntax

test connection connection_name

Example 1 – tests the connection “MyConnPDB”:

test connection MyConnPDB 
go

The returned result is:

 
RESULT
----------
Succeeded
(0 rows affected)