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
- 4018 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 system catalog table in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is db2? Explain.
What is netezza database?
How to execute stored procedures?
What is the maximum size of a char data type in db2?
How to view db2 table structure?
What is a collection in db2?
What is image copy in db2?
How will you return the number of records in table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is role in db2?
What is phantom read in db2?
What db2 400?
How do you select a row using indexes in db2?
