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.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
