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 database reorganization?
Explain dclgen.
B37 abend during spufi?
What is netezza database?
What are packages in db2?
what is a corelated subquerry?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is buffer pool and list some of them?
What is the syntax for FETCH in DB2 ?
What is db2 connect?
What are the 2 sqlcodes that are returned?
Define sqlca.
What is drop table?
What is the meaning concurrency in the db2 database?
What is null value in db2?