In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-13 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
In fact, there is just one more;! This habit can't be changed.
© 2024 shulou.com SLNews company. All rights reserved.