Topic
1 reply Latest Post - ‏2013-06-03T10:50:20Z by JarmoRuuth
adre
adre
1 Post
ACCEPTED ANSWER

Pinned topic create synonym / alias

‏2013-05-24T10:44:26Z |

Hi,, I use soliddb version 6.5 as my database..

i need to create alias or synonym for reference table : catalog_name.schema_name.database_object.

For example : spr.dba.employee_table

synonym : s_employee

can you help me how to resolve that??

 

Best Regard

andre

  • JarmoRuuth
    JarmoRuuth
    20 Posts
    ACCEPTED ANSWER

    Re: create synonym / alias

    ‏2013-06-03T10:50:20Z  in response to adre

    Hi Andre,

    The only way to create a synonym in solidDB is to create a view.

    In this case the view statement could be

    CREATE VIEW S_EMPLOYEE AS SELECT * FROM SPR.DBA.EMPLYEE_TABLE

    Regards,
    Jarmo