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
What is the physical storage length of the data types date, time, and timestamp?
What is temporal table in db2?
What is concurrency?
Name the various locking levels available?
What is consistency token in db2?
What is the difference between oracle and db2?
What are foreign keys in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is scrollable cursor in db2?
What is copy pending status in db2?
What is package in db2 mainframe?
What does runstats do in db2?
What are the uses of db2 optimizer?
What is cursor in dbms?
How is the value function used?