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
- 4112 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a trigger in the db2 database?
How to execute stored procedure in db2 command editor?
What is difference between rollback and commit?
What is the use of db2 optimizer?
What is a db2 table?
What is collection in db2 bind?
How to create db2 table in mainframe?
is it compulsory commitment control in journal?
Why do we bind in db2?
Explain what are the various isolation levels possible?
What is with ur in db2?
Explain about cursor stability?
What is the difference between cursor and select statement?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Why db2 is called db2?
