ShowTempTables database parameter
Description
Specifies whether temporary tables are displayed when you
request a list of tables from the Database painter or SQL Select painter.
Controls
-
ASE, SYC Sybase Adaptive
Server Enterprise
Syntax
|
1 |
ShowTempTables=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether temporary tables 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
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.