What is a synonym? How is it used?
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 is deadlock resolved?
What's the difference between DB2 active log and archive log? Thanks a lot...
What is a DB2 access path?
How and when does the db2 enforces the unique key?
Is it possible to precompile if db2 goes down?
Explain the contents that are a part of dclgen.
What is the size of a data page?
What are the uses of db2 optimizer?
How does coalesce work?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How will fetch last 5 rows from table in db2
what is static sql? what is dynamic sql? Give me details