Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we need to create an alias if we can directly use
the table name? What are the benefits of referring a table
name by its alias?
Also, when should we go for alias and when for synonyms?
- 1 Answers
- 4202 Views
- I also Faced
- E-Mail Answers
Answer / siva
let us consider we have a database with no of tables and one table name is ComputerScienceAndEngineering_Departement
if any one want to access this table they should use full name
ex: select * from ComputerScienceAndEngineering_Departement ;
it may be difficult to someone and sometimes to us also .
so if we creating alias like csedept then it will become simple to access it.
An alias is simply an alternate name for a table or view. Like tables and views, an alias can be created, dropped, and have comments associated with it.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is image copy in db2?
What is db2 connect?
How can you do the explain of a dynamic sql statement?
How to compare data between two tables in db2?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
Where besides the DB2 catalog is database object information stored by DB2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is the picture clause of null indicator variable?
What is normalization and what are the five normal forms?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What is the command used by TSO users to invoke DB2?
Mention the different locking levels that are available in db2.
COBOL 
