Re: Rename a primary key column

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)
.

Relevant Pages

  • Rename a primary key column
    ... hi i am trying to rename a primary using sp_rename. ... message that the column is involved in dependencies. ... dropped all constraints on this table! ...
    (microsoft.public.sqlserver.mseq)
  • Re: Dependencies in Enterprise Manager
    ... If you rename an executable (e.g. ... SQL Server database objects should be treated similarly to other ... > Dependencies' can give the wrong answers, but I don't remember them all. ... > All of this seems to be a HUGE hole in Enterprise Manager. ...
    (microsoft.public.sqlserver.programming)
  • Re: Demotion DC
    ... but the second DC is failing (Hard Disk problems) so I will need ... You cannot even EASILY rename ... contents of the failing drive to new disk. ... Accelerated MCSE ...
    (microsoft.public.win2000.active_directory)
  • Re: How do I get a list of filenames with spaces on bash?
    ... To ensure that in the event of a failure the original file is unaffected. ... in that case, mv doesn't affect the file not even its inode, it ... affects the current directory, it's just a rename. ... A failing cp may leave an ...
    (comp.unix.shell)
  • Re: Fastcode CharPosRev B&V 0.8.0
    ... I know but it does not make sense to rename a failing function and include ... Jeg beskyttes af den gratis SPAMfighter til privatbrugere. ...
    (borland.public.delphi.language.basm)