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
- 3714 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 |
Differentiate between cs and rr isolation levels? Where do you specify them?
how to unload different table data into different gdg files/ vsam files.
What are the functions of Bind?
How can deadlocks be resolved?
What is a Database Request Module(DBRM)?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How do I delete a column in db2?
What is a collection in db2?
what is the difference between join and union?
What is a cursor and what is its function?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
Where is the output of EXPLAIN stored?
COBOL 
