Drops a user-defined execution class.
sp_dropexeclass classname
is the name of the user-defined execution class to be dropped.
This statement drops the user-defined execution class DECISION:
sp_dropexeclass 'DECISION'
An execution class helps define the execution precedence used by Adaptive Server to process tasks. See the Performance and Tuning Guide for more information on execution classes and execution attributes.
classname must not be bound to any client application, login, or stored procedure. Unbind the execution class first, using sp_unbindexeclass, then drop the execution class, using sp_dropexeclass.
You cannot drop system-defined execution classes.
Only a System Administrator can execute sp_dropexeclass.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_addexeclass, sp_bindexeclass, sp_showexeclass, sp_unbindexeclass
Copyright © 2005. Sybase Inc. All rights reserved. |