var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select details of Primary key for list of tbls
I have a list of tables using :
EXEC sp_depends @objname = @Column
I inserted them into a temp table and would like to find the primary key for each table (they may be multicolumn keys) I have no idea how to do this.
Thanks for the help!
query the INFORMATION_SCHEMA views
select name,object_name(parent_object_id) from sys.objects where type = 'pk'