Sybase SQL Remote DC38133-01-0902-01 User Manual
sp_queue_drop procedure
Purpose
To drop the stable queue objects from a database.
Syntax
sp_queue_drop
See also
Description
Drops the stable queue system objects from the database, so that the
database no longer supports a SQL Remote stable queue.
database no longer supports a SQL Remote stable queue.
The sole stable queue object not removed is the sp_queue_drop procedure
itself (a procedure cannot drop itself from a database). To complete removal
of the stable queue requires that sp_queue_drop be dropped explicitly after
it is called.
itself (a procedure cannot drop itself from a database). To complete removal
of the stable queue requires that sp_queue_drop be dropped explicitly after
it is called.
The sp_queue_drop procedure does not remove SQL Remote system
objects from the database. To remove the SQL Remote system objects, use
the
objects from the database. To remove the SQL Remote system objects, use
the
Examples
♦
The following statements remove the stable queue objects from the
database:
database:
sp_queue_drop
go
drop procedure sp_queue_drop
go
414