What is a synonym? How is it used?

Answers were Sorted based on User's Feedback



What is a synonym? How is it used?..

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

What is a synonym? How is it used?..

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

Post New Answer

More DB2 Interview Questions

How is deadlock resolved?

0 Answers  


What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


What is a DB2 access path?

1 Answers  


How and when does the db2 enforces the unique key?

0 Answers  


Is it possible to precompile if db2 goes down?

4 Answers   Target,






Explain the contents that are a part of dclgen.

0 Answers  


What is the size of a data page?

2 Answers   IBM,


What are the uses of db2 optimizer?

0 Answers  


How does coalesce work?

0 Answers  


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  


How will fetch last 5 rows from table in db2

6 Answers  


what is static sql? what is dynamic sql? Give me details

3 Answers  


Categories