Home » RDBMS Server » Server Administration » renaming tables, columns etc....
renaming tables, columns etc.... [message #370535] Fri, 17 December 1999 00:07 Go to next message
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 Go to previous message
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
Previous Topic: SELECT First x Records
Next Topic: Hierarchy in sql
Goto Forum:
  


Current Time: Thu Mar 28 07:33:51 CDT 2024