Issue Details (XML | Word | Printable)

Key: CORE-817
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: tectsoftware
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

ALTER OR CREATE

Created: 14/Jun/04 12:00 AM   Updated: 14/Jun/06 09:42 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 1.5.0

Time Tracking:
Not Specified

SF_ID: 972479


 Description  « Hide
SFID: 972479#
Submitted By: tectsoftware

It might be nice to have the ability to use

ALTER OR CREATE instead of just ALTER or just CREATE
when creating or altering certain objects, this could be
used for

Stored Procedures
Triggers
Views

and maybe some more areas.

i.e.

ALTER OR CREATE PROCEDURE SP_TEST ()
AS
BEGIN
  ...
END;

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alice F. Bird added a comment - 14/Jun/06 09:42 AM
Date: 2005-01-26 05:44
Sender: dtremblay
Logged In: YES
user_id=361043

This is supported for triggers, procedures and views in
Firebird 1.5. I think support was added early on... circa
1.0.3. I may be wrong.

Should probably be marked closed.