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
- 4115 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to resolve -917 sql code in DB2?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is a root page?
wht happens if we close cursor with cursor with hold option?
how 2 resolve the -311 sqlcode
Why cursor is used in db2?
wht is d/f between union and joins ?
What is null indicator in cobol db2?
How can you get the number of rows impacted by the last executed query?
What does reorg do in db2?
Can a Db2 table data be retrived through JCL?
What is the command used by TSO users to invoke DB2?
COBOL 
