Re: Rename a primary key column

hi hugo, yes there are loads of them. however, i finally resolved it all
yesterday. thanks for the reply.

cheers

"Hugo Kornelis" wrote:

> On Tue, 31 May 2005 18:04:02 -0700, "sql guy" <sql
> guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >hi i am trying to rename a primary using sp_rename. but it keeps failing with
> >message that the column is involved in dependencies. but i have already
> >dropped all constraints on this table! any help please
>
> Hi sql guy,
>
> Are there any foreign key constraints on other table that reference the
> primary key column you're trying to rename?
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>
.