Hi,

Is there a way or script to add a new field to existing table in between other fields? I am using Sybase 12.x.

The statement ALTER TABLE <table name> ADD <newfieldname>
will add a new field, but it will be placed as the last field of the table. I would like to insert the new field in between two existing field.

Thanks a lot!

Hey there.. the "view" of the fields, altough not random, could be easily altered by a select statement. Why do you want to add a field in the middle of other two?

And no, you can't in an easy way. (You could create a new table with the field in the correct position and then pass the data to it, but what's the point?).

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi, thanks for the reply. We have an existing system that loads records from a native file to a table. We need to add another column to the native file, and thus to the table also. We cannot drop and recreate the table. And the client wants to retain the order of the fields.

Thanks for your reply anyway! :)

Well, as I said before, you can't without changing the table.

What if you just change the import system???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========