Hi, given a merge table, e.g., sql>create table t1(a int, b real); operation successful (9.315ms) sql>create table t2(a int, b real); operation successful (8.497ms) sql>create merge table mt(a int, b real); operation successful (8.218ms) sql>alter table mt add table t1; operation successful (7.174ms) sql>alter table mt add table t2; operation successful (6.178ms) How can I see which tables are members of a merge tables, i.e., in this case, how can I see that t1 & t2 are members of mt? a plain select (obviously) only shows the content of mt, i.e., the combined content of t1 & t2 ... sql>select * from mt; +---+---+ | a | b | +===+===+ +---+---+ 0 tuples (4.690ms) Is there a query to get this directly from mt, or where can I otherwise find that info in the SQL catalog? Thanks! Stefan -- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |