IMSTAT Procedure (Data and Server Management)
- Syntax
Procedure SyntaxPROC IMSTAT (Data and Server Management) StatementBALANCE StatementCOLUMNINFO StatementCOMPRESS StatementCOMPUTE StatementCREATETABLE StatementDELETEROWS StatementDISTRIBUTIONINFO StatementDROPCOLUMN StatementDROPTABLE StatementFETCH StatementFREE StatementLIFETIME StatementNUMROWS StatementPARTITION StatementPARTITIONINFO StatementPROMOTE StatementPURGETEMPTABLES StatementREPLAY StatementSAVE StatementSCHEMA StatementSCORE StatementSERVERINFO StatementSERVERPARM StatementSERVERTERM StatementSERVERWAIT StatementSET StatementSTORE StatementTABLE StatementTABLEINFO StatementUNCOMPRESS StatementUPDATE StatementQUIT Statement - Overview
- Concepts
- Examples
PURGETEMPTABLES Statement
The PURGETEMPTABLES removes all temporary tables from a server. The action requires server-level authorization because it removes temporary tables created by all users. To execute this command successfully, you must have the same authorization that is required to terminate the server.
Syntax
PURGETEMPTABLES <options>;
Without Arguments
The server to use is
identified from the active table. If you do not have an active table,
then you can connect to a specific server with the HOST= and PORT=
options.
PURGETEMPTABLES Statement Options
HOST="host-name"
specifies the host name for the server. Use this option with the PORT= option.
PORT=number
specifies the port number for the server.
Copyright © SAS Institute Inc. All Rights Reserved.