Interested to Buy Any Domain ? << Click Here >> for more details...
What is a synonym? How is it used?
- 2 Answers
- 5609 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 many buffer pools are available in db2?
How to resolve -818 sql code in DB2?
what is differnece between DROP TABLE & DELETE TABLE .
how can we find nth max salary from A table
What is a storage group (stogroup)?
What is an inner join, and an outer join ?
Is db2 a mainframe?
What are catalog tables in db2?
Can we update view in db2?
What is the advantage in De-normalizing tables in DB2?
What is consistency token in db2?
What is innodb buffer pool?
COBOL 
