What is the difference between SYNONYM and ALIAS?

Answer Posted / ss

YNONYM and ALIAS are alternate names to a table. A SYNONYM
is dropped when the table is dropped whereas an alias is
not dropped if the table it is defined is dropped.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

673


what is db2 restart?

1691


What is with ur in db2?

753


How does a cursor work?

554


Is db2 a mainframe database?

567






What os does db2 run on?

570


Define declaration generator (dclgen).

665


What is a db2 collection?

603


What is the physical storage length of timestamp data type?

644


What is the connection string to connect to the DB2 Database ?

612


What is sqlca’s maximum length?

670


What is the function of logging in the db2 database?

638


How to test SQL -911 error while developing COB-DB2 program

6708


What is performance tuning db2?

616


Is db2 a database?

572