Pages

How to create synonym?

We can create SYNONYM to ease access to objects with short name.

Example: Create synonym st for students table.

CREATE [PUBLIC] SYNONYM st FOR students;


PUBLIC keyword is used to create public synonym for everyone's access.

No comments:

Post a Comment