Hey All,
I'm hoping you might be able to help me out with a problem I'm having.
I was wondering if there is syntax for checking if a column exist. I have to do migration e.g.
Code:
insert into TBLone(
a
,b
,c
,d
,e
,F
)
select
a
,b
,c
,d
,e
,F
From TBLtwo!
My problem is that in "TBLtwo" the column "f" may not exist, so I would want to do the migration if it does exist but if it doest not skip it e.g
Code:
if column F exists
migrate data from TBLtwo.F into TBLone.F
else
Skip migration of that column
Anyone got any suggestions or if I didn't explain that well just shout
Thanks.
dBforums
>
Check for column extistance
11-16-06, 10:22
Linear Mode
