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