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

Popular Posts:

FORM - How to Use IT...

How do I use forms? The basic syntax for a form is: <FORM ACTION="[URL]">...&l t;/FORM>Wh...

How Oracle Handles D...

How Oracle Handles Dead Locks? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle se...

What is Multi-taskin...

.NET INTERVIEW QUESTIONS - What is Multi-tasking ? It’s a feature of modern operating systems with w...

printf() Function...

What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...

C# question: What i...

In C#, what is a weak reference? Generally, when you talk about a reference to an object in .NET (an...