Kbase P138002: How to change the "pub" owner prefix for a table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/2/2008 |
|
Status: Unverified
GOAL:
How to change the "pub" owner prefix for a table
GOAL:
Is there a way to replace the "pub" prefix on SQL for another one ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
It is possible to change the prefix from "pub" for a particular table by creating a synonym.
Example
In order to be able to use a different prefix, like "abc" create a synonym like this:
create synonym abc.customer for pub.customer;
Another option is to create a view.
Example
In order to be able to use a different prefix, like "abc" create a view like this:
create view abc.customer as (select * from pub.customer);
Using either one of these commands, we can now reference the customer table like this:
select count(*) from abc.customer;