🚀 go-pugleaf

Scott Leake wrote:
> I am converting an Interbase 5.6 database that contains column names that
> are reserved words in IB2007. It was backed up in IB5.6 and restored into
> IB2007 with no problem. If I use IBConsole and manually alter the column
> name and save, it works. But I need to automate this process, so I am trying
> to use 
> 
> ALTER TABLE mytable ALTER colname TO newname
> 
> But because it is a reserved word, it doesn't like the command. (One of the
> column names in question is "type"). I have tried several things but can't
> seem to get it to work.
> 
> Is there a way to get Interbase to accept this, at least enough to allow me
> to change the name to something that isn't a reserved word?
> 

You need to double quote the reserved words.  Remember this makes it case 
sensitive so make sure the column is all caps.

-- 
Jeff Overcash (TeamB)
       (Please do not email me directly unless  asked. Thank You)
And so I patrol in the valley of the shadow of the tricolor
I must fear evil. For I am but mortal and mortals can only die.
Asking questions, pleading answers from the nameless
faceless watchers that stalk the carpeted  corridors of Whitehall.
              (Fish)