Shulou(Shulou.com)06/01 Report--

What is a synonym [Synonym]

(1) for some objects with longer names (tables, views, indexes, sequences,. ) subtract and replace it with an alias

The role of synonyms

(1) Shorten the length of object names

(2) facilitate access to other users' objects

Create synonyms corresponding to the salgrade table

Create synonym synonym for table name / view / other object create synonym e for salgrade;create synonym ev5 for emp_view_5

Grant create synonym permission to an ordinary scott user as sys

Grant create synonym to scott

Revoke create synonym permissions from an ordinary scott user as sys

Revoke create synonym from scott

Manipulate salgrade tables using synonyms

Select * from s

Delete synonyms

Drop synonym ev5

Will the deletion of synonyms affect the base table?

Will not affect the base table

Does deleting the base table affect synonyms?

Will affect synonyms

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.