Re: Changing a table name

Peter Jennings wrote: > > Can anyone suggest a reason why we should not change > a table name by updating 'systables'? > -- snip -- > > Or is there a better way of doing it? > > Peter Jennings. As several people have pointed out to me, I should be using RENAME TABLE old TO new I thought this was only available in V 7 (I forgot to say I was using V 5) but now I look, it's in the V 5 manual. RTFM Peter! (and I'd been looking in the ALTER TABLE section for this 8-{ ). Thanks to everyone who replied. Peter Jennings.