Chat now with support
Chat mit Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

Retrieve Description of Tables and Views

You can retrieve the description for a table or view which gives you the column definitions, data type, and length of the column. This function is not available until text is highlighted in the Editor pane.

To retrieve the table description

  1. In the Editor pane of the SQL Worksheet window, highlight a table or view name.

  2. Click image\B_sp_help.gif.

Note: The information is retrieved from the database using the sp_help procedure. Whatever text you highlight is sent to Adaptive Server as the parameter to sp_help. If you highlight an entire SQL statement, Adaptive Server executes sp_help without a parameter and executes the SQL statement. The SQL Worksheet then displays the result of both executions.

 

Related Topic

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen