sql Definition UNION ALL (SQL) Similar to UNION, UNION ALL is an SQL keyword that unions two tables. The difference is that UNION ALL preserves duplicate rows.