One can easily list all the primary keys of a table by running simple query… SELECT Col.Column_Name from INFORMATION_SCHEMA.TABLE_CO... Tab, INFORMATION_SCHEMA.CONSTRAI... Col WHERE Col.Constraint_Name = Tab.Constraint_Name AND Col.Table_Name = Tab.Table_Name AND Constraint_Type = 'PRIMARY KEY ' AND Col.Table_Name = '<your table name>' Hope this help...