|
Home > Archive > MS SQL Server MSEQ > June 2005 > Rename a primary key column
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Rename a primary key column
|
|
| sql guy 2005-05-31, 8:25 pm |
| 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
| |
| Hugo Kornelis 2005-06-01, 8:24 pm |
| On Tue, 31 May 2005 18:04:02 -0700, "sql guy" <sql
guy@discussions.microsoft.com> 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)
| |
| sql guy 2005-06-02, 3:23 am |
| 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@discussions.microsoft.com> wrote:
>
>
> 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)
>
|
|
|
|
|