Add a where clause:
WHERE NOT IN (SELECT key_column_usage.COLUMN_NAME FROM information_schema.table_constraints
INNER JOIN information_schema.key_column_usage
ON table_constraints.constraint_name = key_column_usage.constraint_name
WHERE
table_constraints.constraint_type = 'PRIMARY KEY' AND table_constraints.table_name = 'table_name')
?
Woodie Westbrook
I came, I saw, I compiled.