|Subject||Re: [ib-support] Trouble with SQL dialects|
> What I'd do - grab IB_SQL (free from www.ibobjects.com). Use it to connect to your db and use its Extract tool to get a metadata script. Save the output to a text file and then go in there and edit out all the quoted identifiers.I'll second that - it takes a little getting used to, but
the other advantage is that you get a chance to review the
field sizes and types as well, and can remove other niggles
on the way.
I use this method quite a lot while sorting the structure of
the database out. Adding and deleting colunms while
'playing' creates a mess, and so you then build a clean
metadata and pump the real data in.
If you just want to do a quick tidy up because doing the
proper job will take to long now, create new columns with
clean names, 'UPDATE XxX SET XXX=XxX', and then drop the old
column. If you do that in IB_SQL, then you will be able to
use the data and then decide what the real metadata should
L.S.Caine Electronic Services