SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 03:58 PM
| ||||
| ||||
 aliases/nicknames for fields? Im working on a database that's in process study for reformulation/migration and one attribute is actually aggregating more meanings than on the previous DB. Since we wouldn't like to change the whole older app just to migrate, i was questioned about the possiblity of a field have 2 names. Any ideas? Thanks Alexandre      |
|
02-26-2008, 03:58 PM
| ||||
| ||||
| Re: aliases/nicknames for fields? You're best off to create a view for the table with the new column names you want. If there are no RI dependencies/MQT's/triggers on the table, you could then rename it, and rename the view to have the table's original name. Alexandre H. Guerra wrote: > Im working on a database that's in process study for > reformulation/migration and one attribute is actually aggregating more > meanings than on the previous DB. > > Since we wouldn't like to change the whole older app just to migrate, > i was questioned about the possiblity of a field have 2 names. > > Any ideas? > Thanks > > Alexandre |
Linear Mode
