Subject | Re: [firebird-support] Cannot drop stored procedures with reserved names |
---|---|
Author | Ivan Prenosil |
Post date | 2006-08-02T16:18:52Z |
> I've been using Gábor Gazsó excellent stored procedure library, but afterChange database dialect from 1 to 3 (e.g. using gfix),
> switching to Firebird 1.5.2, I noticed that the SP library overlaps the
> reserved words in FB. Now I can't seem to be able to drop the procedures
> such as Month, Year, etc.
>
> Must I attack the RDB$ tables to expunge these references?
then use double quotes and uppercase letters to name the objects, like
DROP PROCEDURE "YEAR";
Ivan