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
- 4203 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
How do I connect my db2 database to ibm?
How can you quickly find out the # of rows updated after an update statement?
What is bind and rebind in db2?
What is ibm db2 connect?
Describe major components of db2?
Highlight all the advantages that are attached to a package.
Why db2 is called db2?
What is coalesce in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the role of union all and union
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Are views updateable?
What is the difference between spufi and qmf?
What are the contents of dclgen?
