What is the difference between SYNONYM and ALIAS?
- 6 Answers
- 26413 Views
- TCS, I also Faced
- E-Mail Answers
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 the latest version of ibm db2?
What is the maximum size of varchar data type in db2?
What is bind in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Can you use max on a char column?
What is db2 bind?
What is meant by dclgen?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What language is db2 written in?
Is db2 a mainframe database?
What are db2 tables?
Explain about rct.
What is concurrency?
How does cobol compile db2 program?
What is the difference between cursor stability and repeatable read isolation levels?
