ShowTempTables

Description

Specifies whether temporary tables are displayed when you request a list of tables from the Database painter or SQL Select painter.

Applies to

Syntax

ShowTempTables=value

Parameter

Description

value

Specifies whether temporary tables are displayed when you request a list of tables. Values are:

Default

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

Example 1

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.