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
-
In the Editor pane of the SQL Worksheet window, highlight a table or view name.
-
Click
.
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.