"A.M." <agentm@cmu.edu> wrote:
> I have 560 columns of NUMERIC(10,14). To not run up against max column
> restraints, I split the information into two tables. Does the column
> limit on tables imply the same limit for views or selects or could I
> potentially select a row across both tables and make a view that hides
> the split?
Hi,
just for curiosity, can I known why do you need a table or a view
with more then 560 Columns ?
Usually have a big table like yours is sign of a not good design.
Regards
Gaetano Mendola