DROP PROCEDURE

Purpose

Removes a stored procedure from a database

Syntax

DROP PROCEDURE [<database>!]<procname>

See Also

ADATABASES(), ADD TABLE, ALTER INDEX, ALTER TABLE, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, CREATE DATABASE, CREATE PROCEDURE, CREATE TABLE, CREATE INDEX, CREATE VIEW, DATABASE(), DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), LIST DATABASE, LIST INDEXES, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET AUTOCATALOG, SET DATADIR, SET EXCLUSIVE, SET SQL, USE

Description

The DROP PROCEDURE command removes a stored procedure from a database and physically deletes the file. If the database name, <database>!, is specified, the stored procedure will be removed from that database, otherwise the stored procedure will be removed from the currently open database. If no database is open and no <database>! is specified, an error occurs. The <procname> can include the '.prg' file extension, but if this is not specified it will be assumed.

Example

OPEN DATABASE southwind
DROP PROCEDURE creaxml