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