General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks! it is a good idea to do everything offline during midnight!
>>I can use "alter table add column" to add a new column at the end of the table column definition. Is there a way to add the new column at a particular position, such as before or after a certain existing column?
>>
>>Thanks!
>
>I think, not with ALTER TABLE - apparently, the column position is deemed irrelevant.
>
>You might, however, do a CREATE TABLE and then use APPEND FROM, for example. See also COPY STRUCTURE EXTENDED.
>
>Personally, in Bata/Bolivia I make all database changes manually, in an empty database (i.e., none of the tables has records), and then I run a process, at midnight, that basically does an APPEND FROM for each table, into the new (empty) structure.
javascript:MessageSubmit()
[Save this message so it will appear for other members immediately]
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only