Subject Re: [Firebird-Architect] ALTER OR CREATE statements
Author Martijn Tonies
Hi Simon,

> Are there any plans to add ALTER OR CREATE statements for certain objects
> within FB
>
> I would be a lot simpler to have:
>
> ALTER OR CREATE PROCEDURE SP_TEST ()
> AS
> BEGIN
> ...
> END;
>
> Than:
>
> CREATE PROCEDURE SP_TEST ()
> AS
> BEGIN
>
> END;
>
> Followed by the procs body:

But, this isn't required perse. You can create a procedure
with a full body just fine.

> ALTER PROCEDURE SP_TEST ()
> AS
> BEGIN
> ...
> END;

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com