VIEWS or SYNONYM's
380441Jun 10 2004 — edited Jun 11 2004Dear List,
I have a simple TABLE called country (ID_COUNTRY, ENGLISH, GERMAN, FRENCH)
The first 2 rows could be.
INSERT INTO COUNTRY(...) (1, 'Germany', 'Deutschland', 'Allemagne');
(2, 'Great Britain', 'Großbritannien', 'Grande-Bretagne');
I would like to create an object, available for users outside our app., where ID_COUNTRY =1 always is shown for example as "DE", which is the ISO 3166-1 country code. I am not sure, but I guess I could use a SYNONYM and a VIEW combined ?
This would mean we would not need to change our database schema, but it would make us sort of ISO compatible ;)
I hope someone can help,
Ben