Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Modifying primary key column order without dropping ?

2 posts in Windows NT Last posting was on 2001-01-12 16:53:31.0Z
Didier Blanchard Posted on 2001-01-12 11:51:47.0Z
From: "Didier Blanchard" <didier.blanchard@informatique.stp.telepost.fr>
Subject: Modifying primary key column order without dropping ?
Date: Fri, 12 Jan 2001 12:51:47 +0100
Lines: 7
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <Y1eSCEJfAHA.267@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: Mix-Montsouris-105-1-34.abo.wanadoo.fr 193.250.60.34
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1327
Article PK: 1088793

I have a table with a primary key that consist of col1 and col2.
Is it possible to modify the column order of the PK (col1-col2 ==>
col2-col1) without dropping the table ?

Thank you for helping me.


joe buhl Posted on 2001-01-12 16:53:31.0Z
Reply-To: "joe buhl" <jbuhl@video-on.com>
From: "joe buhl" <jbuhl@video-on.com>
References: <Y1eSCEJfAHA.267@forums.sybase.com>
Subject: Re: Modifying primary key column order without dropping ?
Date: Fri, 12 Jan 2001 09:53:31 -0700
Lines: 15
Organization: video-on
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <6Al6WrLfAHA.216@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 12.41.162.201
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1325
Article PK: 1088791

Certainly. Just drop and recreate the constraint or index. but you can't
reorder the column order of the table without dropping it.
joe

"Didier Blanchard" <didier.blanchard@informatique.stp.telepost.fr> wrote in
message news:Y1eSCEJfAHA.267@forums.sybase.com...
> I have a table with a primary key that consist of col1 and col2.
> Is it possible to modify the column order of the PK (col1-col2 ==>
> col2-col1) without dropping the table ?
>
> Thank you for helping me.
>
>