Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

primary keys

Status
Not open for further replies.
dky1e

dky1e

Programmer
May 4, 2002
293
US
Hi,

I need to get information on which fields on a table are primary keys, using sql script. Which system tables/information schema views should I look into?

Thanks.
 
Sort by date Sort by votes
with :

sp_primarykeys

or u can get information from sysobjects

select * from sysobjects where xtype = 'PK'

Regards.
 
Upvote 0 Downvote
Thanks,

Can I get to it using the information_schema views?
 
Upvote 0 Downvote
I got it.
INFORMATION_SCHEMA.TABLE_CONSTRAINTS

sweet!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BTrees
  • Locked
  • Question
Incremental Load (No primary key) 2
Replies
2
Views
412
Olaf Doschke
Olaf Doschke
BxWill
  • Locked
  • Question
TSQL - Bulk Insert - Composite Primary Keys - Cannot insert the value NULL into column 2
Replies
6
Views
352
BxWill
BxWill
BxWill
  • Locked
  • Question
TSQL - Create Foreign Keys - Error: There is already an object named FK_EquipMaster" 2
Replies
8
Views
547
Olaf Doschke
Olaf Doschke
Auguy
  • Locked
  • Question
Primary Key Creation - Suggestions 2
Replies
6
Views
206
Auguy
Auguy
duartevds
  • Locked
  • Question
SQL 2012 - Consistency validation for sql server registry keys
Replies
1
Views
281
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top