renaming tables, columns etc.... [message #370535] |
Fri, 17 December 1999 00:07 |
Barry O'Sullivan
Messages: 1 Registered: December 1999
|
Junior Member |
|
|
I have a database whose tables, columns etc are written in French. I have English translations and want to implement them. What is the best way to do this?
Thanks for your help......
Barry
|
|
|
Re: renaming tables, columns etc.... [message #370544 is a reply to message #370535] |
Fri, 17 December 1999 07:15 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Barry
You can
CREATE table ENGLISH_TABLE_NAME as
SELECT FRENCH_COL1 as ENG_COL1,
FRENCH_COL2 as ENG_COL2,
-- keep going till all columns listed
FROM FRENCH_TABLE_NAME;
Hope this helps,
Paul
|
|
|