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?
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 the difference between nvl and coalesce?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Which isolation level provides maximum concurrency?
What are iseries servers?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the use of value function?
What is netezza database?
What is cursor stability in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is the maximum No of rows per page?
What is the picture clause of null indicator variable?
What is the reason behind not using select * in embedded sql programs?
What is a buffer in memory?
How do I delete a column in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?