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


Please Help Members By Posting Answers For Below Questions

What is the difference between nvl and coalesce?

843


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

1855


Which isolation level provides maximum concurrency?

927


What are iseries servers?

808


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

894


What is the use of value function?

873


What is netezza database?

799


What is cursor stability in db2?

1080


What is the difference between using bind () and rebind () methods of naming class?

1111


What is the maximum No of rows per page?

846


What is the picture clause of null indicator variable?

918


What is the reason behind not using select * in embedded sql programs?

875


What is a buffer in memory?

825


How do I delete a column in db2?

891


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2701