Use sp_drop_resource_limit to drop a resource limit from an Adaptive Server.
The syntax is:
sp_drop_resource_limit {name , appname } [, rangename, limittype, enforced, action, scope]
Specify enough information to uniquely identify the limit. You must specify a non-null value for either name or appname.
See sp_drop_resource_limit in the Reference Manual: Procedures.