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
What is release/acquire in bind?
What is sqlca?
Define predicate?
Why do we use cursor?
What do you mean by cursor?
How does a cursor work?
What is a db2 cursor?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How do I import a csv file into db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is check constraint. Explain with example.
What is drop table?
What parameters are used to control the free space in DB2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is netezza database?