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, 5415👍, 0💬

Popular Posts:

Bitwise Operations...

Which bit wise operator is suitable for checking whether a particular bit is on or off? The bitwise ...

From performance poi...

From performance point of view how do they rate ? Repeater is fastest followed by Datalist and final...

How To Insert Multip...

How To Insert Multiple Rows with a SELECT Statement? - MySQL FAQs - Managing Tables and Running Quer...

Session Tracking wit...

How can I enable session tracking for JSP pages if the browser has disabled cookies? We know that se...

Vector and ArrayList...

What is the main difference between a Vector and an ArrayList? Java Vector class is internally synch...