Re: [SQL] table restruct...

2001-09-20 Thread Thurstan R. McDougle
"David M. Richter" wrote: > snip... > Yes I have to do . Now I solved that problem with rename the original > table study to _study > then create the new right structured table study , Insert into study > (chilioid,...,...) SELECT * FROM _study; > Ok not elegant but it works. > > Another questio

Re: [SQL] table restruct...

2001-09-20 Thread Stephan Szabo
On Thu, 20 Sep 2001, David M. Richter wrote: > Hi! > > Thanks, to You! > > Yes I have to do . Now I solved that problem with rename the original > table study to _study > then create the new right structured table study , Insert into study > (chilioid,...,...) SELECT * FROM _study; > Ok not el

Re: [SQL] table restruct...

2001-09-20 Thread David M. Richter
Hi! Thanks, to You! Yes I have to do . Now I solved that problem with rename the original table study to _study then create the new right structured table study , Insert into study (chilioid,...,...) SELECT * FROM _study; Ok not elegant but it works. Another questions: Can I change the physic

Re: [SQL] table restruct...

2001-09-20 Thread Kovacs Baldvin
Hi! Do you REALLY need to restructure your data for changing columns? Probably you could use views instead. Üdv, Baldvin ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]