SELECT
table_name,
column_name,
data_type,
CASE WHEN constraint_type = 'P' THEN 'PRI' ELSE '' END as column_key
FROM (
SELECT
t.table_name,
t.column_name,
t.data_type,
c.constraint_type
FROM user_tab_columns t
LEFT JOIN (
SELECT cons.table_name, cols.column_name, cons.constraint_type
FROM user_constraints cons
JOIN user_cons_columns cols ON cons.constraint_name = cols.constraint_name
WHERE cons.constraint_type = 'P'
) c ON t.table_name = c.table_name AND t.column_name = c.column_name
)
ORDER BY table_name, column_id;
Step 3 Paste the results from the above query
Step 4 Describe what you want to query
Example Query
See how the AI generates SQL from natural language
-- Find all customers who made purchases over $1000 last month
SELECT c.name, SUM(o.amount) as total_spent
FROM customers c
JOIN orders o ON c.id = o.customer_id
WHERE o.date >= DATE_SUB(NOW(), INTERVAL 1 MONTH)
GROUP BY c.id
HAVING total_spent > 1000;