Interested to Buy Any Domain ? << Click Here >> for more details...
What is a synonym? How is it used?
- 2 Answers
- 5709 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Synonym is alternate name for a table.
Use of synonyms avoids changes to programs when you migrate
programs from test to production.
create synonym abc for test.abc in test
create synonym abc for prod.abc in production
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vinod
A synonym is used to reference a table or view by another
name. The other name can then be written in the application
code pointing to test tables in the development stage and to
production entities when the code is migrated. The synonym
is linked to the AUTHID that created it.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I import data from excel to db2?
what is the process of precompiler?
What is package in cobol db2?
In terms of DB2 indexing, what is the root page?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What is null indicator in cobol db2?
Explain about rct.
What is view db2?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
what is different three logs in DB2?
What is a bind in db2?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
COBOL 
