2005/10/11, Dusan Kolesar <[EMAIL PROTECTED]>: > Hello list, > is it posible to change column order in the table ? > I want to add some column into the table, but not to the end. > Is it posible in SapDb, or I must drop table firs and recreate it with > correct order?
I know no RDBMS that allows to do this (apart from maybe SQL Server but there it's a dirty hack of the EM: it deletes the table and recreates it, something you definitely don't want for large tables). After all, you don't really need that. You can arrange columns in every oder you like when querying the table. If you have a view on "select *" you should rewrite that anyway... Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
