Description
Specifies whether temporary tables are displayed when you request a list of tables from the Database painter or SQL Select painter.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
Syntax
ShowTempTables=value
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether temporary tables are displayed when you request a list of tables. Values are:
|
Default value
ShowTempTables=1
Usage
The ShowTempTables database parameter applies only to database connections from within the development environment. When ShowTempTables=1, a request for a list of database tables from within a painter causes both sp_pb100table and sp_pb100temptab to execute. The union of these two result sets is displayed to the user. If ShowTempTables=0, only sp_pb100table is executed. The behavior is the same if the stored procedures are not installed on the ASE server.
Examples
To specify that you want to display temporary tables, select the Show Temp Tables check box on the System page in the Database Profile Setup dialog box.
