Interested to Buy Any Domain ? << Click Here >> for more details...
What is a synonym? How is it used?
- 2 Answers
- 5468 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 |
what needs to be done if a table is in copy pending / check pending status?
What is db2 catalog database?
What is the difference between bind and rebind in db2?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What do you need to do before you do EXPLAIN ?
What is performance tuning db2?
What is the syntax required for the creation of a cursor?
What does the REORG Utility do?
What language is db2 written in?
what's the best lock size that you could use when you create a tablespace?
What is a clustering index?
What is db2? Explain.
COBOL 
