What is the difference between SYNONYM and ALIAS?
Answer Posted / nandivardhanreddy.n
when the table is dropped automatically synonym is dropped
and it is a private variable.
when the table is dropped alias is not dropped because it
is invalid and it is global variable.
synonym can accesed by the user who creates it
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How do I start db2 in windows?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Explain the contents that are a part of dclgen.
What parameters are used to control the free space in DB2?
How do I add a column in db2?
What is the difference between db2 and oracle?
Are views updateable?
What's The Error Code For Unique Index Voilation?
What is commit in db2?
What is the use of runstats in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is role in db2?
what is the sqlcode -501
Which are the db2 tools to protect integrity of the database?