Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

What are synonyms?

Add comment
Views: 68
Votes: 0
Comments: 0
Synonyms give you the ability to provide alternate names for database objects. You can alias object names; for example, using the Employee table as Emp. You can also shorten names. This is especially useful when dealing with three and four part names; for example, shortening server.database.owner.object to object.
Others in this Category
document What are Ranking Functions?
document What is the difference between UNION and UNION ALL?
document What are the authentication modes in SQL Server? How can it be changed?
document What are different types of Collation Sensitivity?
document What is SQLCMD?
document Name 3 ways to get an accurate count of the number of records in a table?
document Q: Explain the concept of NULL
document What is XPath?
document What are the basic functions for master, msdb, model, tempdb and resource databases?
document What is the STUFF function and how does it differ from the REPLACE function?
» More articles



RSS