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 blu acceleration in db2?

612


What are the two types of logging in the db2 database? Explain them.

585


Explain about mirror activator disk mirroring?

564


Describe major components of db2?

644


What is dbrm? What it contains? When it will be created?

597






How do I start db2 in windows?

578


What is concurrency?

713


define clustering index.

625


Differentiate between cs and rr isolation levels? Where do you specify them?

591


what is utility for parm lib

1892


What is null in db2?

579


What's The Percentage Free Space ?

785


What is ibm db2 database?

543


What is the use of db2 optimizer?

619


What is schema in db2?

580