What is the difference between SYNONYM and ALIAS?
Answer Posted / ss
YNONYM 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 is dropped.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is rct?
Where can you declare a cursor in a cobol-db2 program?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Explain about dbrm.
What are iseries servers?
What are the two types of logging in the db2 database? Explain them.
What do you mean by commit and rollback?
How and when does the db2 enforces the unique key?
How to access db2 tables in mainframe?
How do I delete a table in db2?
What is consistency token in db2?
What is dbrm in db2 database?
i want to maintain uniqueness on pdf without make lf??????????
What do you mean by cursor?
What is buffer pool in the db2 database?