What is the difference between SYNONYM and ALIAS?
Answer Posted / s
SYNONYM and ALIAS are alternate names to a table. A SYNONYM
is dropped when the table is dropped whereas an alias is
not dropped if the table it is defined on is not dropped.
| Is This Answer Correct ? | 26 Yes | 17 No |
Post New Answer View All Answers
How can we retrieve the total number of records in RPG & CLLE?
Highlight all the advantages that are attached to a package.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is db2 bind process?
What is the physical storage length of the data types date, time, and timestamp?
What is the use of value function?
Explain the contention situations caused by locks?
Explain what are the various isolation levels possible?
What is the clustering index in the db2 database?
What is iseries database?
i want to maintain uniqueness on pdf without make lf??????????
What are catalog tables in db2?
What is cursor in dbms?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
If I have a view which is a join of two or more tables, can this view be updateable?