Article View: borland.public.interbase.opensource
Article #92Re: Dynamically change order of fields
From: Bill Todd
Date: Sat, 07 Apr 2007 01:24
Date: Sat, 07 Apr 2007 01:24
15 lines
1419 bytes
1419 bytes
AntonE wrote: > Is there a way to change the order (in the IB metadata) for fields in > a table? Similar to IBConsole where you can alter a table & 'push' > fields up or down? > > Thanks With recent versions of IB you can change the column order using the ALTER TABLE statement. I do not recall if this is possible with IB 6 or not. The real question is why bother? You can specify any column order you want in your SELECT statement. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<4616e4ad$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4616bc14@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,67f3059fb80ce7b6
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Dynamically change order of fields
Newsgroups: borland.public.interbase.opensource
References: <4616bc14@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <4616e4ad$1@newsgroups.borland.com>
Date: 6 Apr 2007 17:24:13 -0800
X-Trace: newsgroups.borland.com 1175905453 216.207.211.19 (6 Apr 2007 17:24:13 -0800)
Lines: 15
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail