USE NORTHWIND
SELECT COLUMN_NAME FROM Information_schema.KEY_COLUMN_USAGE WHERE Table_Name='Categories'

Anyone have a more efficient way? I know there is somewhere!