Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > DROP ROUTINE >

Modifying SPL Routines (XPS)

Extended Parallel Server does not support the ALTER PROCEDURE, ALTER ROUTINE, or ALTER FUNCTION statements. To change the text of an SPL routine, you must drop the routine and then re-create it. Make sure to keep a copy of the SPL routine text somewhere outside the database, in case you need to re-create the procedure after you drop it.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]