At 02:33 PM 7/20/2012, Bruce Chitiea wrote:
I'm experimenting with table creation at the R>Prompt. Wanting to
bullet-proof
my approach to coding. An UNLOAD of one existing table shows the sequence:
CREATE TABLE ...
ALTER TABLE ... ADD PRIMARY KEY ...
AUTONUM ...
RULES ...
RULES ...
To COMMENT ON elements, would I:
a) Append them after RULES, or
b) Insert them between the existing elements?
Bruce,
The best experiment would be to create a scenario manually, and then use the
bullet-proof option of "Unload Definition with Constraints, Indexes, and
Comments" to see how R:BASE engine creates a file with correct sequence,
using the latest and greatest versions of R:BASE, of course!
Here's how:
01. Start R:BASE eXtreme 9.1/9.5 for Windows
02. CONNECT dbname
03. Database Explorer | Tables ...
04. Highlight/Select the appropriate table | Right Click | Unload ...
Select Definition with Constraints, Indexes, and Comments
Once the file is created, then open that file using R:BASE Editor and
look at the sequence.
COMMENTing all columns and then table should be the very last block.
That's all there is to it.
Hope that helps!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
