Changing the Column order

#1

Hi guys,

I'm using SQL Anywhere 9.0.2 3702 on Windows 2003 server.

I was wondering how to change the column order of a
particular table without dropping that table?

Is there a way?

Regards,

Chris

#2

No, you have to drop and re-CREATE the table to change the column
order.

Or, you could create a view with the desired order.

Breck

On 21 Aug 2009 15:11:24 -0700, Christopher Ceniza wrote:

Quote:

Hi guys,

I'm using SQL Anywhere 9.0.2 3702 on Windows 2003 server.

I was wondering how to change the column order of a
particular table without dropping that table?

Is there a way?

Regards,

Chris

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

#3

Thanks.

Quote:

No, you have to drop and re-CREATE the table to change the
column order.

Or, you could create a view with the desired order.

Breck

On 21 Aug 2009 15:11:24 -0700, Christopher Ceniza wrote:

Hi guys,

I'm using SQL Anywhere 9.0.2 3702 on Windows 2003 server.

I was wondering how to change the column order of a
particular table without dropping that table?

Is there a way?

Regards,

Chris

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Changing the Column order

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Changing the Column order - 08-21-2009 , 05:11 PM

Re: Changing the Column order - 08-22-2009 , 07:58 AM

Re: Changing the Column order - 08-24-2009 , 01:42 AM