Posted by Erland Sommarskog on 01/09/07 22:32

(danielbuus@gmail.com) writes:
> Thanks for the tip. There was a small typo, though (parentpbj instead
> of parent_obj), and the select would just get all constraints on
> authors and then rename the first one which wasn't necessarily the
> primary key constraint, so I narrowed it down with a LIKE 'PK%'
> statement.

Oops. I should have added

AND xtype = 'PK'




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: INNER JOIN/Index Threshold?
• Prev in forum: Re: Idea: new database object that defines a FROM clause
• Thread view: Re: Redefining an auto-generated primary key constraint name

[Reply to this message]