Interested to Buy Any Domain ? << Click Here >> for more details...
What is a synonym? How is it used?
- 2 Answers
- 5521 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 is the maximum No of rows per page?
What is the logical entity between plan and Package?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Highlight all the advantages that are attached to a package.
Is ibm db2 free?
what are the SQL codes u freequently got?
What is cursor stability in db2?
what is a corelated subquerry?
What is SPUFI?
When Can you be sure that a query will return only one row?
COBOL 
