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

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

    Re: create synonym / alias

    ‏2013-06-03T10:50:20Z  

    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