InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 15:36:19 GMT20http://www.sqlservercentral.com/Forums/Topic617744-1433-1.aspxKiran -Do you have a version of your query for MS SQL 2000?Fri, 02 Jan 2009 08:25:19 GMTirene.floydhttp://www.sqlservercentral.com/Forums/Topic617744-1433-1.aspxYes ...this code will only work with 2005/8 I think...Fri, 02 Jan 2009 08:17:12 GMTpeterhailshttp://www.sqlservercentral.com/Forums/Topic617744-1433-1.aspxWhat version of SQL are you using?I got these error messages when I tried your code in MS SQL 2000:Server: Msg 208, Level 16, State 1, Line 5Invalid object name 'sys.columns'.Server: Msg 208, Level 16, State 1, Line 5Invalid object name 'sys.key_constraints'.Fri, 02 Jan 2009 08:00:57 GMTirene.floydhttp://www.sqlservercentral.com/Forums/Topic617744-1433-1.aspxThats great Kiran...For interest I have modified this to just show Unique cols plus PK for the param table:create PROCEDURE [dbo].[GetUniqueCols]@table_name nvarchar(50)ASselect c.name as [Column_Name], kc.name as [Constraint_Name], object_name(c.object_id) as [Table_Name]from sys.columns cjoin sys.key_constraints kcon (c.column_id = kc.unique_index_id and c.object_id = kc.parent_object_id)where kc.type='UQ' or kc.type = 'PK'and c.object_id = object_id(@table_name)GROUP BY c.name,kc.NAME, object_name(c.object_id)Having object_name(c.object_id)=@table_nameFri, 02 Jan 2009 02:30:23 GMTpeterhailshttp://www.sqlservercentral.com/Forums/Topic617744-1433-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/PK/65218/">Getting unique or primary key columns for a given table</A>[/B]Thu, 11 Dec 2008 04:27:35 GMTKiran-339615