A method and computer system for structure subset generation for multiple
databases is disclosed. The method retrieves a database view object
structure. The method includes inputting definition language specifying a
database view identifier and with at least one directly or indirectly
referenced database object unqualified with a containing database
identifier. The method further includes inputting a show statement that
identifies the database view identifier and outputting the definition
language with each directly or indirectly referenced database object
qualified with its containing database identifier.