6
Answers

Stored procedure to give primary key column details of table

Prasad Godbole

Prasad Godbole

12y
2.1k
1
Hi

We want to write a stored procedure which will give what are the primary keys of a specific table and what are its data type etc.. i.e. details about that column such as type and length

we have tried following SPROC

EXEC sp_pkeys '<table name>'

Also this SPROC should work on Microsoft SQL Server 2000, 2005, 2008 and its later version.

Please advise us in this.

Thanks and Regards
Prasad


Answers (6)
1
Bryian Tan

Bryian Tan

NA 9.4k 887.3k 12y
Hi,

It sound like you have version 655 but the mdf version is 661 (from MS SQL Server R2). There are couple of options.

  1. upgrade your SQL Server 2008 to SQL Server 2008 R2
  2. use the Generate Scripts tool to generate scripts for the database objects (abc) and run the script on your SQL server.
NOTE: You might have Microsoft SQL Server 2008 R2 Management Studio on your machine but that doesn't mean that you have Microsoft SQL Server 2008 R2
Accepted
1
Bryian Tan

Bryian Tan

NA 9.4k 887.3k 12y
Right click the database, Tasks, Generate Scripts...

http://msdn.microsoft.com/en-us/library/ms178078%28v=sql.105%29.aspx
1
mahesh kumar B M

mahesh kumar B M

NA 42 1.1m 12y
hi, where do we find this Generate Scripts tool to generate scripts for the database objects and plz share the link if its available. What are the steps to be followed to convert from sql server 2008 to sql server 2006 R2