Super Table

From: In2Home User <user_at_forlano.in2home.co.uk>
Date: Sat, 2 Oct 1999 01:28:01 +0100
Message-ID: <938824352.2845.0.pink.d4e11207@news.in2home.co.uk>

I have the same table structure represented in many different schemas: schema1.test, schema2.test, etc.

Where test has columns, say: id, title, designer, status.

Can I create a view that appears to be a single table representing all the data
in each test table in all the schemas? If so, how?

What I'd like is a view that has columns: schema, id, title, designer, status.

So if schema1.test has 200 records and schema2.test has 400 records, the view will have 600 records.

If I cannot use a view, is there a better way to do this than using triggers to populate
two tables ... rather costly?

Thanks,

Chris Received on Fri Oct 01 1999 - 19:28:01 CDT