SELECT c.column_name, ordinal_position > FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc > JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu > ON tc.CONSTRAINT_name = ccu.CONSTRAINT_name > AND tc.table_name = ccu.table_name > JOIN INFORMATION_SCHEMA.COLUMNS c > ON ccu.Column_name = c.Column_name > AND ccu.table_name = c.table_name > WHERE CONSTRAINT_type = 'PRIMARY KEY' > And tc.table_name = 'titles'Thanks Sergey. I'm going to spend some time getting familiar with the Information Schema views and the info they provide.