Skip to main content
Skip to main content

merge Table Function

Creates a temporary Merge table. The structure will be derived from underlying tables by using a union of their columns and by deriving common types.

Syntax

Arguments

ArgumentDescription
db_namePossible values (optional, default is currentDatabase()):
- database name,
- constant expression that returns a string with a database name, for example, currentDatabase(),
- REGEXP(expression), where expression is a regular expression to match the DB names.
tables_regexpA regular expression to match the table names in the specified DB or DBs.