EM: Databases/SQL: Databases > SQL

Description

The Databases SQL tab in Enterprise Manager provides an interactive interface for executing SQL statements against the selected database. Administrators can enter and format queries, enable or disable autocommit, limit returned rows, and execute statements directly from the editor. Authentication credentials or an authentication token may be supplied for secure access. Query results and execution status are displayed in the Messages panel.

Note: selecting a database from Databases name list, opens its configuration interface, enabling access to SQL and other databases.

Toolbar

Button	Function
	Executes all SQL statements currently entered in the SQL editor.
Format	Formats the SQL query.
Viewer	Selects the ResultSet viewer type, displaying query results in Grid or Text format.
Autocommit	When unchecked, disables automatic commits, enabling manual Commit and Rollback transaction control buttons. When checked, automatically commits each executed SQL statement, disabling Commit and Rollback controls.
	Commits SQL statements executed in the current SQL panel.
	Rolls back uncommitted SQL statements in the current session.
Database	Selects the active database for executing SQL statements.
Limit Rows	Disables row limit and prevents editing maximum row count value. Enables row limit and allows editing maximum row count value.
Use Auth Token User	When unchecked, enables manual User and Password entry for standard authentication credentials. When checked, uses authentication token for connection and disables manual User and Password fields.
User	The username used for database authentication during connection.
Password	The password associated with the provided username for authentication.
Properties	Allows entry of additional connection properties as user-defined parameters.

Location

EM Navigator → Databases/SQL → Databases → SQL

SQL Editor Panel

The SQL Editor allows administrators to enter, execute, and manage SQL statements against the selected database, displaying results and execution messages within the interface.

Messages Panel