|
View previous topic :: View next topic
|
| Author |
Message |
kumar_ngl
Warnings : 1
New User
Joined: 05 Aug 2005
Posts: 50
Location: chennai
|
|
|
|
hay all,
plz clear me the differents between alias and view. will alias require physical storage?? and how abt view???
thanx,
kumar.p.v |
|
| Back to top |
|
 |
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
|
|
Hi Kumar,
VIEW : is a set of some columns from one or more table, to fetch data from a database. Also termed as vertual table.
ALIAS: is used to refer a table or a VIEW by alternative name.
| Quote: |
| will alias require physical storage?? and how abt view??? |
VIEW doesnt.
Corrections welcome.
Regards,
Priyesh. |
|
| Back to top |
|
|
kumar_ngl
Warnings : 1
New User
Joined: 05 Aug 2005
Posts: 50
Location: chennai
|
|
|
|
hi priyesh,
thanx for ur answer
kumar.p.v |
|
| Back to top |
|
|
gowtham_srgp
New User
Joined: 09 Jun 2005
Posts: 38
|
|
|
|
| kumar_ngl wrote: |
hay all,
plz clear me the differents between alias and view. will alias require physical storage?? and how abt view???
thanx,
kumar.p.v |
hai.... alias is an alternate name given to a base table. it helps us to refer the base tabel without the full qualifiers. view is going to be a window of the base tabel. it does reside separate whereas, my alias has a separate storage.
corrections welcomed.....
gowtham |
|
| Back to top |
|
|
|
|
