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

Popular Posts:

How to prevent my .N...

.NET INTERVIEW QUESTIONS - How to prevent my .NET DLL to be decompiled? By design .NET embeds rich M...

What is the differen...

What is the difference between CALL_FORM, NEW_FORM and OPEN_FORM? CALL_FORM: start a new form and pa...

What Does a HTML Doc...

What Does a HTML Document Look Like? A HTML document is a normal text file with predefined tags mixe...

How do we get the cu...

How do we get the current culture of the environment in windows and ASP.NET? “CultureInfo.CurrentCul. ..

DBMS questions with ...

it will be very helpful if you send some important Questions with Answers of DBMS Tell us what types...