Get Primary Key columns of given MSSQL table

By vanaspati, 2007/02/14

This procedure will give the list of columns included in the primary key for a given table of given database on given server.
For. e.g.
Get_PrimaryKey 'vrs-118','Demo_StDB','IMAGEREPOSITORY'

Total article views: 925 | Views in the last 30 days: 3

FORUM

Check given number

how to check the given number is decimal

FORUM

Synonym-Given String

Sql Server Query -help(Synonym for Given String)

FORUM

Insert query to distribute given amount

Insert rows dynamically to distribute given Amount

FORUM

display the days for given month

FORUM

returning data for a given month

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

Get Primary Key columns of given MSSQL table

Check given number

Synonym-Given String

Insert query to distribute given amount

display the days for given month

returning data for a given month

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: