What is difference between Rename and Alias?

✍: Guest

Rename is actually changing the name of an object whereas Alias is giving another name (additional name) to an existing object.

Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.

2011-12-22, 5149👍, 0💬

Popular Posts:

init() vs. Construct...

Can we use the constructor, instead of init(), to initialize servlet? Yes , of course you can use th...

what is a service co...

what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...

How can we connect t...

How can we connect to Microsoft Access , Foxpro , Oracle etc ? Microsoft provides System.Data.OleDb ...

What is Concern in A...

What is Concern in AOP? gA concern is a particular goal, concept, or area of interesth There are m...

How do I install JUn...

How do I install JUnit? First I will download the lastest version of JUnit. Then I will extract all ...