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
- 4017 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 |
What does the sqlcode of -818 pertain to?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is cursor in dbms?
Which component is responsible for db2 startup and shutdown?
What is performance tuning db2?
What is the maximum No of rows per page?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What are the uses of db2 optimizer?
What is isolation level in db2?
What happens to a cursor after a commit?
How would the varchar column remarks defined?
wht steps we need will coding cobol and db2 pgm ?
COBOL 
