Changing Primary key names to standard naming convention across the DB

By Vidyadhar Pandekar, 2011/07/29

Copy the script into Query window
Select the appropriate database
Select Query Result to Text from the Query Menu
Execute the script
Copy the result/ output script in the query window
Select the same database
Execute the script
Validate the primary key names changed.

*Note-

PK_TableName is considered as standard primary key notation

Script works even if PK is referred by FK.

Total article views: 1610 | Views in the last 30 days: 1

SCRIPT

Transpose Query Output

script to return query result transposed.

BLOG

A Script A Day - Day 7 - Memory Queries

Today's script is a collection of a few memory queries I've collected from various sources over the ...

FORUM

VS2008 - just query scripts?

Can I run Alter Table script from VS2008?

FORUM

Scripting help - Need a query to find filenames and filepaths under a certain directory

FORUM

VS2008 - just query scripts?

Can I run Alter Table script from VS2008?

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Changing Primary key names to standard naming convention across the DB

Transpose Query Output

A Script A Day - Day 7 - Memory Queries

VS2008 - just query scripts?

Scripting help - Need a query to find filenames and filepaths under a certain directory

VS2008 - just query scripts?

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: