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.
RE: What is difference between Rename and Alias?...
the difference is that
rename is used to change the name of the column or table! alias it is a name given to table which is used as an object extracting the information from the table and gives more meaning to query implemented! it is just like an object.variable which we use in OOP's concept!
RE: What is difference between Rename and Alias?...
I would like add one more point.
Rename will change the name of the coulmn/table permanently , where as alias is Query Specific ( name of the coulmn is changed for the query reference).
RE: What is difference between Rename and Alias?...
Rename of a column or table is a permanent change where alias is a object for a column or table where it can be referred instead of using a long column or table names. For eg. usage of alias is 1. Joins 2. Subqueries
RE: What is difference between Rename and Alias?...
Rename is used for changing the name of the column or table. where as alias is the command used tio change the column name for query purpose. Basically alias are used mostly in joins
RE: What is difference between Rename and Alias?...
alias is temporary name from column/table . we can't participate in any operation using that alias name. where as rename is a new name given for exiting table or column name.. using this name we can participate in any operations. when ever we given rename for table/column the old name is no more in database
1 
0