ShowTempTables – PB Docs 2019

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

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.