-- Step 1: Run SHOW PRIMARY KEYS
SHOW PRIMARY KEYS IN TABLE my_schema.my_table;
-- Step 2: Query the result
SELECT *
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));