What is difference between Rename and Alias?
Q
What is difference between Rename and Alias?
✍: Guest
A
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, 4435👍, 0💬
Related Topics:
What are various joins used while writing SUBQUERIES?
What are various joins used while writing SUBQUERIES? =, , IN, NOT IN, IN ANY, IN ALL, EXISTS, NOT EXISTS. 2011-12-23, 3302👍, 0💬