Razzak:
Very handy, PROJECT. Been learning just how handy, of late; but I hadn't thought of that.
Thanks!
Bruce
-------- Original Message --------
Subject: [RBASE-L] - Re: ALTER TABLE: Column ordering
From: "A. Razzak Memon" <[email protected]>
Date: Fri, June 29, 2012 10:46 am
To: [email protected] (RBASE-L Mailing List)
At 01:33 PM 6/29/2012, Bruce Chitiea wrote:
>I can't see where the ALTER TABLE <tblname> ADD COLUMN ... syntax
>allows positioning of
>the created column within its table. So I go to the Data Designer for that.
>
>Is there any such command line feature?
Bruce,
FWIW, the positioning of table columns is an eXclusive feature of
R:BASE Data Designer.
However, you may use the PROJECT command to define a temporary table
with all columns
in the order as you wish, and then DROP the actual table (if not
constraint by PK/FK
relationship), and finally PROJECT the temporary table to the actual
table name.
HELP PROJECT will illustrate it all!
Hope that provides you with some blue's clues ...
Very Best R:egards,
Razzak.
