What is the difference between SYNONYM and ALIAS?

Answer Posted / kp

Synonym is private to the user who has defined the Synonym
and also the synonym cannnot refer to a remote table

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is phantom read in db2?

640


How to connect to db2 database from windows command line?

563


How do I add a column in db2?

595


B37 abend during spufi?

982


What are foreign keys in db2?

616






What is null indicator in cobol db2?

586


Can we update view in db2?

562


What is node in db2?

610


Why db2 is called db2?

595


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7518


What is syscat in db2?

580


What is meant by dclgen?

618


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

719


i want to maintain uniqueness on pdf without make lf??????????

1635