bLaK wrote:CREATE VIEW -- leaving out the one column
We have a kind of requirement where we have 2 exact schema's with some 450 tables (on same database). Now whenever there is any insert/update/delete on schema1.table1 then same changes should be applied on schema2.table1 (same database)... The difference between 2 schema is that there is one extra column in all tables of schema1 which should not be available on schem2 tables.
The thing that we can do is to write a trigger for each 450 tables... but i don't think that would be the best solution.. can someone please suggest what could be the better way to implement this..?
bLaK wrote:Interesting ! So the application that uses 2nd schema also does some DMLS there ? Or it is read only kind of thing ?
Thanks for the reply sb92075..
But we actually need 2 physical structure and two diff schema's... they will be used by two diff application.. So can't really go with view...